Postgres Pro
Downloads
Home   >   mailing lists

Re: PG gets slower over time - Mailing list pgsql-general

From Mike Diehl
Subject Re: PG gets slower over time
Date
Msg-id 200911031733.05047.mdiehl@diehlnet.com
Whole thread Raw
In response to Re: PG gets slower over time  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PG gets slower over time
Next
From: Scott Marlowe
Date:
Subject: Re: auditing pg_hba.conf