Re: [HACKERS] default_stats_target WAS: Simple postgresql.conf wizard

2008-12-02 Thread Aidan Van Dyk
* Josh Berkus <[EMAIL PROTECTED]> [081202 15:54]: > 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

Re: [HACKERS] default_stats_target WAS: Simple postgresql.conf wizard

2008-12-02 Thread Josh Berkus
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 ex