PG gets slower over time

[Mike Diehl (Encrypted email preferred)]

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.

--
Sent via pgsql-general mailing list (pgsql-general@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Craig Ringer]

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

--
Sent via pgsql-general mailing list (pgsql-general@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Mike Diehl (Encrypted email preferred)]

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.

--
Sent via pgsql-general mailing list (pgsql-general@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general