On Thu, Dec 10, 2009 at 11:45 AM, Greg Smith <g...@2ndquadrant.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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
