Re: The science of optimization in practical terms? - Mailing list pgsql-hackers

From Kevin Grittner
Subject Re: The science of optimization in practical terms?
Date
Msg-id 49981952.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: The science of optimization in practical terms?  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-hackers
>>> Greg Smith <gsmith@gregsmith.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


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: The science of optimization in practical terms?
Next
From: "BogDan Vatra"
Date:
Subject: Re: SE-PostgreSQL and row level security