PG gets slower over time - Mailing list pgsql-general

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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: pg_dump on Linux with pg_restore on Windows?
Next
From: JP Fletcher
Date:
Subject: auditing pg_hba.conf