Postgres Pro
Downloads
Home   >   mailing lists

EFFECTIVE_CACHE_SIZE - Mailing list pgsql-general

From Joseph Shraibman
Subject EFFECTIVE_CACHE_SIZE
Date
Msg-id 3EEF9E49.2010503@selectacast.net
Whole thread Raw
Responses Re: EFFECTIVE_CACHE_SIZE
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Arguile
Date:
Subject: Re: Link to Bruce M's fs performance tuning doc
Next
From: Tom Lane
Date:
Subject: Re: order of nested loop