| From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
|---|---|
| To: | "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us> |
| Cc: | "Mark Wong" <markwkm(at)gmail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com>, "Gregory Stark" <stark(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-20 01:07:25 |
| Message-ID: | D425483C2C5C9F49B5B7A41F894415470100128D@postal.corporate.connx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)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(at)postgresql(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2008-11-20 03:53:52 | Re: Cool hack with recursive queries |
| Previous Message | Bruce Momjian | 2008-11-20 01:06:40 | Re: Updates of SE-PostgreSQL 8.4devel patches (r1197) |