From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
Cc: | pgsql-performance(at)postgresql(dot)org, gnuoytr(at)rcn(dot)com |
Subject: | Re: How does PG know if data is in memory? |
Date: | 2010-10-21 18:55:18 |
Message-ID: | 201010211855.o9LItI113723@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Kevin Grittner wrote:
> <gnuoytr(at)rcn(dot)com> wrote:
>
> > -- None of that is anything for amateurs to play with.
> >
> > Not jam a stick in anybody's eye, but shouldn't database pros not
> > be amateurs?
>
> While many PostgreSQL installations are managed by professional
> DBAs, or programmers or consultants with a deep enough grasp of the
> issues to tune a knob like that appropriately, PostgreSQL is also
> used in environments without such staff. In fact, there is pressure
> to make PostgreSQL easier to configure for exactly that reason. If
> we add more knobs which are this hard to tune correctly, we would
> risk inundation with complaints from people to tried to use it and
> made things worse.
Agreed. Here is a blog entry that explains some of the tradeoffs of
adding knobs:
http://momjian.us/main/blogs/pgblog/2009.html#January_10_2009
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-10-21 19:07:58 | Re: BBU Cache vs. spindles |
Previous Message | Tim Goodaire | 2010-10-21 18:54:48 | Experiences with running PostgreSQL on Blue Arc Network Storage |