Re: EFFECTIVE_CACHE_SIZE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: postgres <pgsql-general(at)postgresql(dot)org>
Subject: Re: EFFECTIVE_CACHE_SIZE
Date: 2003-06-18 00:13:24
Message-ID: 17970.1055895204@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> 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?

No, it'd bias towards indexscans. IIRC the parameter is only used to
cost indexscans, and a larger value will tend to make indexscans look
cheaper.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-06-18 00:18:53 Re: Sort memory not being released
Previous Message Tom Lane 2003-06-18 00:12:18 Re: [PERFORM] Interesting incosistent query timing