From: | Thomas Finneid <tfinneid(at)fcon(dot)no> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | explanation of some configs |
Date: | 2009-02-07 00:52:17 |
Message-ID: | 498CDB41.1010007@fcon.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi
I am having some problem understanding the details of a couple of
configuration directives. Here is what I think I understand it so far:
effective_cache_size
- specifies in how many B/KB/MB will be used to cache data
between pg and the OS?
- what is actually cached and how it is actually used by the
planner and how does it affect the planner and the queries?
-in other words, when and why do I need to set this parameter?
checkpoint_segments
- specifies the number of segments?
size: number*16MB?
- means when number of WAL segments has filled up and matches
checkpoint segment, dirty data is written to disk?
- so it specifies how much data is stored in memory/wal before
written to disk and therefore affects recoverability?
regards
thomas
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2009-02-07 00:59:11 | Re: explanation of some configs |
Previous Message | Scott Carey | 2009-02-07 00:10:39 | Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller |