PG gets slower over time

From: Mike Diehl <mdiehl(at)diehlnet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: PG gets slower over time
Date: 2009-11-03 22:49:08
Message-ID: 200911031549.08771.mdiehl@diehlnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andre Lopes 2009-11-03 23:08:29 Postgres for mobile website?
Previous Message JP Fletcher 2009-11-03 22:41:39 auditing pg_hba.conf