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.