Vlad <marchenko@gmail.com> writes:
> we use tablespace feature to keep indexes on a dedicated raid array
> (for performance). What I've noticed is that when the index were
> created, based on the i/o activity it seemed that postgres was
> creating the index file somewhere on the array where the default table
> space is hosted and the data is stored.
Temp files are created in $PGDATA/base/yourdb/pgsql_tmp/. If you have a
mind to, you can replace that subdirectory with a symlink to a (suitably
secure) directory elsewhere.
regards, tom lane
