> 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 Lane||Date: 2001-11-16 06:16:27|
|Subject: Re: switching from mysql |
|Previous:||From: Brad Hilton||Date: 2001-11-16 01:16:08|
|Subject: switching from mysql|