Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: pg_dump on Linux with pg_restore on Windows?
Next
From: Mike Diehl
Date:
Subject: Re: PG gets slower over time