On Thu, Dec 10, 2009 at 11:45 AM, Greg Smith <greg@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
