On Tuesday 17 July 2007 17:47:01 Tom Lane wrote:
> mljv@planwerk6.de 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