Marc Cousin <cousinmarc@xxxxxxxxx> wrote: > As mentionned in another mail from the thread (from Richard Huxton), > I felt this message in the documentation a bit misleading : > > effective_cache_size (integer) > Sets the planner's assumption about the effective size of the disk > cache that is available to a single query > > I don't really know what the 'a single query' means. I interpreted > that as 'divide it by the amount of queries typically running in > parallel on the database'. Maybe it should be rephrased ? (I may not > be the one misunderstanding it). I'm afraid I'll have to let someone else speak to that; I only have a vague sense of its impact. I've generally gotten good results setting that to the available cache space on the machine. If I'm running multiple database clusters on one machine, I tend to hedge a little and set it lower to allow for some competition. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
