> I have a transaction running at the database for around 20 hours .. still
> isn't done. But during the last hours it has come to the point where it
> really hurts performance of "other queries".
> Given pg_stat_activity output there seems to be no locks interfering but
> the overall cpu-usage of all queries continue to rise. iowait numbers are
> also very low.
> What can I do to make the system handle other queries better?
Can you post the query? Do you 'vacuum analyze' on a regular basis?
You can also post your conf-file and post the last five lines from a
'vacuum analyze verbose'.
When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.
In response to
pgsql-performance by date
|Next:||From: Grzegorz Jaśkiewicz||Date: 2009-09-24 08:44:09|
|Subject: Re: Speed while runnning large transactions.|
|Previous:||From: jesper||Date: 2009-09-24 08:27:46|
|Subject: Speed while runnning large transactions. |