Re: Simple postgresql.conf wizard

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
> owner@postgresql.org] On Behalf Of Robert Haas
> Sent: Wednesday, November 19, 2008 5:05 PM
> To: Bruce Momjian
> Cc: Mark Wong; Tom Lane; Heikki Linnakangas; Gregory Stark; Josh
> Berkus; Greg Smith; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Simple postgresql.conf wizard
>
> > Yes, please test something.  I am tired if us saying we need to
> increase
> > default_statistics_target, but because we don't know the magic
> number,
> > we do nothing release after release.
>
> I think the idea that there IS a magic number is the problem.
>
> No amount of testing is ever going to refute the argument that, under
> some other workload, a different value might better.
>
> But that doesn't amount to a reason to leave it the way it is.

Perhaps a table of experimental data could serve as a rough guideline.