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 ?


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to