Milan Zamazal wrote:
PS> and value efective_cache_size ???effective_cache_size = 128MB
thats rather small unless your systme is very memory constrained. assuming postgres is the primary disk IO consumer on this ysstem, take a look at the 'cached' value on TOP or whatever after its been running, thats a good first order estimate of effective_cache_size.... this is often half or more of your physical memory.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
