| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Dann Corbit <DCorbit(at)connx(dot)com>, Gregory Stark <stark(at)enterprisedb(dot)com>, Decibel! <decibel(at)decibel(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Mark Wong <markwkm(at)gmail(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Simple postgresql.conf wizard |
| Date: | 2008-11-26 01:38:09 |
| Message-ID: | 1227663489.11899.73.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2008-11-25 at 20:33 -0500, Tom Lane wrote:
> "Dann Corbit" <DCorbit(at)connx(dot)com> writes:
> > I also do not believe that there is any value that will be the right
> > answer. But a table of data might be useful both for people who want to
> > toy with altering the values and also for those who want to set the
> > defaults. I guess that at one time such a table was generated to
> > produce the initial estimates for default values.
>
> Sir, you credit us too much :-(.
Better than not enough :)
> So we really don't have any methodically-gathered evidence about the
> effects of different stats settings. It wouldn't take a lot to convince
> us to switch to a different default, I think, but it would be nice to
> have more than none.
I don't this is not empirical but really, 150 is very reasonable. Let's
just set it to that by default and be done with it. It won't hurt
anything and if they need more than that, they are already investigating
either via the lists or via a vendor anyway.
Joshua D. Drake
>
> regards, tom lane
>
--
PostgreSQL
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2008-11-26 01:56:12 | Re: Simple postgresql.conf wizard |
| Previous Message | Tom Lane | 2008-11-26 01:33:23 | Re: Simple postgresql.conf wizard |