Re: PostgreSQL performance deteriorates over time? - Mailing list pgsql-novice

From Tom Lane
Subject Re: PostgreSQL performance deteriorates over time?
Date
Msg-id 23010.1005886502@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL performance deteriorates over time?  (tvahakan@fw.cluster.net)
List pgsql-novice
tvahakan@fw.cluster.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

pgsql-novice by date:

Previous
From: Brad Hilton
Date:
Subject: switching from mysql
Next
From: Tom Lane
Date:
Subject: Re: switching from mysql