Re: default_stats_target WAS: Simple postgresql.conf wizard

Mark,

> Generally
> speaking, it seems like on un-tuned systems increasing the
> default_statistics_target for this workload doesn't have a clear
> benefit.

Do you have any idea how skewed the distribution of data for DBT3 is?  If 
values are being generated in relatively equal proportion, I'd expect 
increasing DST to have little effect.  The databases where higher DST is 
useful is ones with skewed data distribution.

Unfortunately, all the data examples I could point to are proprietary 
customer databases :-(

-- 
--Josh

Josh Berkus
PostgreSQL
San Francisco