Re: The science of optimization in practical terms?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Greg Smith" <gsmith(at)gregsmith(dot)com>
Cc: <jd(at)commandprompt(dot)com>,"Bernd Helmle" <mailings(at)oopsware(dot)de>, "Grzegorz Jaskiewicz" <gj(at)pointblue(dot)com(dot)pl>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: The science of optimization in practical terms?
Date: 2009-02-15 19:32:02
Message-ID: 49981952.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> Greg Smith <gsmith(at)gregsmith(dot)com> wrote:
> have a second count that assumes the last
> 2*shared_buffers evicted are also still cached.

Perhaps it would be better to assume that the external cache is
effective_cache_size - shared_buffers? Of course, we would need to
have some heuristics to cover odd settings (like effective_cache_size
less than shared_buffers).

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message BogDan Vatra 2009-02-15 19:55:56 Re: SE-PostgreSQL and row level security
Previous Message Greg Smith 2009-02-15 18:16:32 Re: The science of optimization in practical terms?