Re: Revisiting default_statistics_target - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Revisiting default_statistics_target
Date
Msg-id 4A2ABE36.1040203@agliodbs.com
Whole thread Raw
In response to Re: Revisiting default_statistics_target  (Mark Wong <markwkm@gmail.com>)
Responses Re: Revisiting default_statistics_target  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Mark,

> On the DL380 GB system, where I'm using a lot more drives the Jignesh,
> I see a performance change of under 5%.  15651.14 notpm vs 16333.32
> notpm.  And this is after a bit of tuning, not sure how much the out
> of the box experience changes on this system.

Well, Jignesh and I identified two things which we think are "special" 
about DBT2: (1) it uses C stored procedures, and (2) we don't think it 
uses prepared plans.

I've been unable to reproduce any performance drop using pgbench.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_migrator issue with contrib
Next
From: Joe Conway
Date:
Subject: Re: [Fwd: Re: dblink patches for comment]