Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL performance deteriorates over time?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: tvahakan(at)fw(dot)cluster(dot)net
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: PostgreSQL performance deteriorates over time?
Date: 2001-11-16 04:55:02
Message-ID: 23010.1005886502@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
tvahakan(at)fw(dot)cluster(dot)net writes:
> Using libpq++ simple UPDATE has gone from under
> one millisecond to over 20 milliseconds after a few days of
> uptime (mostly idle)? VACUUM ANALYZE didn't help, but
> restarting postmaster did.

This seems *very* odd; restarting the postmaster should not make a
difference.  What exactly is the query you're using, what exactly
is the table and index schema, and what does EXPLAIN say is the
query plan (in both fast and slow states)?

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2001-11-16 06:16:27
Subject: Re: switching from mysql
Previous:From: Brad HiltonDate: 2001-11-16 01:16:08
Subject: switching from mysql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group