PG gets slower over time
Hi all.
I've got a database server that's been running for years now, but lately I've
had to restart it occasionally.
It seems to get slower and slower until I break down and restart it. Then it
runs well. (I vacuum regularly.)
It sounds to me like I've got some "stuck" connections, but I don't know how
to confirm this. Any other suggestions would be welcome, also.
--
Take care and have fun,
Mike Diehl.
Mike Diehl wrote:
It sounds to me like I've got some "stuck" connections, but I don't know how
to confirm this. Any other suggestions would be welcome, also.
Have a look at pg_catalog.pg_stat_activity
--
Craig Ringer
On Tuesday 03 November 2009 05:09:26 pm Craig Ringer wrote:
Mike Diehl wrote:
It sounds to me like I've got some "stuck" connections, but I don't know
how to confirm this. Any other suggestions would be welcome, also.Have a look at pg_catalog.pg_stat_activity
--
Craig Ringer
That helped a lot! Thank you.
--
Take care and have fun,
Mike Diehl.