On Tuesday 17 July 2007 17:47:01 Tom Lane wrote: > mljv@xxxxxxxxxxxx writes: > > i think i got it fixed as i saw that i pushed my maintenance_work_mem too > > high. It was higher than physical ram :-( > > Ooops, that will definitely cause problems. yes it did! I ran it again. And now it takes 10 minutes per index instead of 10 hours (still 8.1). maybe something postgres should complain about if setting maintance_work_mem too high. Thanks for your help. kind regards janning
