Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
On Wed, 2006-12-13 at 18:36 -0800, Josh Berkus wrote:
Mostly, though, pgbench just gives the I/O system a workout. It's not a
really good general workload.
It also will not utilize all cpus on a many cpu machine. We recently
foun
Just a wild guess, but the performance problem sounds like maybe as your
data changes, eventually the planner moves some query from an index scan
to a sequential scan, do you have any details on what queries are taking
so long when things are running slow? You can turn on the GUC var
"log_min_
Steven Flatt wrote:
Here is a potential problem with the auto-vacuum daemon, and I'm
wondering if anyone has considered this. To avoid transaction ID
wraparound, the auto-vacuum daemon will periodically determine that it
needs to do a DB-wide vacuum, which takes a long time. On our system,
i
