Re: Revisiting default_statistics_target

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