| 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: | Whole Thread | Raw Message | 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 |