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

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