> 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'. -- regards Claus When lenity and cruelty play for a kingdom, the gentler gamester is the soonest winner. Shakespeare -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
