On Thursday 26 December 2002 06:09 pm, Tom Lane wrote:
> Is it likely that someone else was doing the same thing in another
> session?
no ANALYZE in parallel but another client constantly running transactions
(over 6 tables with approx. 20 - 100 updates/inserts per transaction).
The postgres client generates a permanent cpu load of 80-90% for days.
To keep the transaction rate at a reasonable level we run a "vacuumdb -z"
via a shell script in a while-loop with a "sleep 3600" in between.
I suspect the vacuumdb returns to the shell when the ANALYZE has finished,
so it should be impossible that two ANALYZE were running at the same time (?)
As long as it's harmless, we can live with that.
Btw.: is there a tool to check the consistency of a postgres database?
regards,
harald.