"Todd A. Cook" <tcook@xxxxxxxxxxxxxxxxxxxxx> writes: > I have found that increasing maintenance_work_mem can decrease index > build speed on large tables: You should probably re-measure when 8.2 comes out; we've fixed a number of performance issues in the sorting code that might cause that. regards, tom lane