From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
---|---|
To: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, "Joshua Drake" <jd(at)commandprompt(dot)com>, "Magnus Hagander" <magnus(at)hagander(dot)net>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Hans-Juergen Schoenig" <postgres(at)cybertec(dot)at> |
Subject: | Re: A smaller default postgresql.conf |
Date: | 2008-08-20 14:31:53 |
Message-ID: | 200808201031.54742.xzilla@users.sourceforge.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wednesday 20 August 2008 02:22:26 Jaime Casanova wrote:
> On Tue, Aug 19, 2008 at 9:40 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> writes:
> >> I'd still like to see us adopt the proposal from some time ago where
> >> we stop commenting out the parameters at all, but short of that,
> >> hiding options seems about the worst choice we could make.
> >
> > Well, there seems to be a very substantial body of opinion that says
> > we *do* need to hide "uninteresting" options.
>
> more to the point... not just "uninteresting" but "dangerous for the
> uninformed" ones...
> i have seen to many people turning off fsync in OLTP systems 'cause
> someone tolds them that will improve speed...
> and work_mem setted at 256Mb because that improves a bad query that
> should be rewritten as something more sanely...
This is a false argument, because people can just as easily be told "you
should add fsync=off into you blank postgresql.conf" and then they are in the
same boat.
Most of the newbie confusion comes from a lack of understanding of how and
what to tune. Adding a full on tuning guide into the docs would help with
that. Untill then, we should point them to
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-08-20 14:33:07 | Re: A smaller default postgresql.conf |
Previous Message | Zdenek Kotala | 2008-08-20 14:31:13 | Re: Patch: plan invalidation vs stored procedures |