Re: How does PG know if data is in memory?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <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-12 15:11:29
Message-ID: 4CB434510200002500036817@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<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.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message bricklen 2010-10-12 15:12:53 Re: Slow count(*) again...
Previous Message gnuoytr 2010-10-12 14:49:44 Re: How does PG know if data is in memory?