Re: Performance problems??? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Performance problems???
Date
Msg-id 2341.1004473970@sss.pgh.pa.us
Whole thread Raw
In response to Performance problems???  (James Patterson <jpatterson@amsite.com>)
List pgsql-hackers
James Patterson <jpatterson@amsite.com> writes:
> I have observed some disturbing behavior with the latest (7.1.3) version of
> PotgreSQL.

Try vacuuming the "control" table every so often --- you're accumulating
huge numbers of dead rows in it.

Even better, replace "control" with a sequence object.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Performance problems???
Next
From: Jason L Tibbitts III
Date:
Subject: Re: pgsql-committers?