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