On 09/06/12 1:34 PM, Kobus Wolvaardt wrote:
Something that is curios is that if a DB takes long, it really takes
horribly long like some kind of a lock is holding it. It would sit at
a few kb dump size for 20 minutes en then run a bit and get stuck
again (as far as we can tell), what we do know is that it is way to
slow for some IO or cpu starvation. We have seen a 5GB backup sitting
at 1Gb after 12hours and then we stop it.
Any siggestions? Can autovacume or lack thereof cause this? It seems
noone has been doing any maintenance on the DB (it does look like
autovacuum is running), so any suggestions would be nice.
try...
select * from pg_stat_activity;
select * from pg_locks;
next time its hung
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
