Re: dbt-2 tuning results with postgresql-8.3.5 - Mailing list pgsql-performance

From Gregory Stark
Subject Re: dbt-2 tuning results with postgresql-8.3.5
Date
Msg-id 871vw0v5ot.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: dbt-2 tuning results with postgresql-8.3.5  ("Mark Wong" <markwkm@gmail.com>)
Responses Re: dbt-2 tuning results with postgresql-8.3.5
List pgsql-performance
"Mark Wong" <markwkm@gmail.com> writes:

> Thanks for the input.

In a more constructive vein:

1) autovacuum doesn't seem to be properly tracked. It looks like you're just
   tracking the autovacuum process and not the actual vacuum subprocesses
   which it spawns.

2) The response time graphs would be more informative if you excluded the
   ramp-up portion of the test. As it is there are big spikes at the low end
   but it's not clear whether they're really part of the curve or due to
   ramp-up. This is especially visible in the stock-level graph where it
   throws off the whole y scale.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Next
From: Laszlo Nagy
Date:
Subject: Slow table update