Christopher Smith <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org