Markus Bertheau <[EMAIL PROTECTED]> writes: >> You could probably improve the index-create time by temporarily >> increasing sort_mem. It wouldn't be unreasonable to give CREATE INDEX >> several hundred meg to work in. (You don't want sort_mem that big >> normally, because there may be many sorts happening in parallel, >> but in a data-loading context there'll just be one active sort.)
> Doesn't this provide a reason for CREATE INDEX not to honour sort_mem? Already done for 7.5. http://archives.postgresql.org/pgsql-committers/2004-02/msg00025.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster