On Thu, Dec 10, 2009 at 11:45 AM, Greg Smith <greg(at)2ndquadrant(dot)com> wrote:
> So your shared buffers setting is 8192 * 8K = 64MB
> effective_cache_size is 8MB
> work_mem is 4MB.
>
> The first and last of those are reasonable but on the small side, the last
> is...not.
I believe that the second instance of the word "last" in that sentence
should have been "middle", referring to effective_cache_size. Small
values discourage the planner from using indices in certain
situations.
...Robert