> Could you run the cron job more often? That way, you'd be spreading
> the pain and each VACUUM ANALYSE would be doing less work.
It wouldnt change that much i suppose. I think the bottleneck is a table
which contains about 2.5 million records.
Even when running "vacuum analyse" twice without changing data in between
the second takes also a lot of time.
Also at night the usage of the Database is noticable less.
When starting Vacuum @daytime i can instantly watch the number of
postmasterclients and the sysload increasing very fast. Are the tables
writelocked during vaccum?
Thanks
Thilo