Christopher Smith <christopherl_smith@yahoo.com> writes:
> disk space ran out. Is it possible to predict the filename to be used
> for indexes and hence create a link to another open disk.
No, but you might get some joy by adjusting the pgsql_tmp subdirectory
of your database to symlink to a temp directory on another disk. The
peak disk usage during a CREATE INDEX is going to have about as much
temp space as finished-index space ...
regards, tom lane