From: "Hervé Piedvache" <[EMAIL PROTECTED]>
Sent: Tuesday, July 13, 2004 11:42 PM
> effective_cache_size = 5000000
looks like madness to me.
my (modest) understanding of this, is that
you are telling postgres to assume a 40Gb disk
cache (correct me if I am wrong).
btw, how much effect does this setting have on the planner?
is there a recommended procedure to estimate
the best value for effective_cache_size on a
dedicated DB server ?
gnari
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
