Skip site navigation (1) Skip section navigation (2)

Re: dbt-2 tuning results with postgresql-8.3.5

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Mark Wong" <markwkm(at)gmail(dot)com>
Cc: "pgsql-performance\(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, "Selena Deckelmann" <selenamarie(at)gmail(dot)com>, "Gabrielle Roth" <gorthx(at)gmail(dot)com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: 2008-12-22 10:56:50
Message-ID: 871vw0v5ot.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-performance
"Mark Wong" <markwkm(at)gmail(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Laszlo NagyDate: 2008-12-22 11:06:02
Subject: Slow table update
Previous:From: Gregory StarkDate: 2008-12-22 10:35:35
Subject: Re: dbt-2 tuning results with postgresql-8.3.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group