EFFECTIVE_CACHE_SIZE

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: postgres <pgsql-general(at)postgresql(dot)org>
Subject: EFFECTIVE_CACHE_SIZE
Date: 2003-06-17 23:03:37
Message-ID: 3EEF9E49.2010503@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the effect of EFFECTIVE_CACHE_SIZE? What happens if I set it too low or too high?
Does a higher setting bias the planner more toward seq scans?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-06-17 23:07:02 Re: order of nested loop
Previous Message Ernest E Vogelsinger 2003-06-17 23:01:09 Re: [PERFORM] Interesting incosistent query timing