> So one very effective way of speeding this process up is giving the
> vacuum process lots of memory, because it will have to do fewer passes
> at each index. How much do you have?

OK, this is my problem... it is left at default (16 megabyte ?). This
must be a mistake in configuration, on other similar boxes I set this to
262144 (256 megabyte). The box has 4 Gbyte memory.

Thanks for the explanation - you were right on the spot, it will likely
solve the problem.

Cheers,
Csaba.




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly