Gavin Hamill <gdh@xxxxxxxxxxxxx> writes: > The table has just under six million rows - should it really be taking > nearly six minutes to add an index? Try running it with trace_sort enabled to get more info about where the time is going. We've been doing some considerable work on the sorting code in the last couple months, so 8.2 should be better, but I'd like to verify that you're not seeing something we don't know about. > maintenance_work_mem = 262144 Fooling with this might affect the results some. regards, tom lane
