| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | u15074 <u15074(at)hs-harz(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Checkpoint question |
| Date: | 2003-07-21 14:41:01 |
| Message-ID: | 4621.1058798461@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
u15074 <u15074(at)hs-harz(dot)de> writes:
> Can you specify more exactly what you mean with update rate? I moslty perform
> inserts on the database (is that what you mean?).
Sure, inserts/updates/deletes.
> Also I do not understand, why checkpoint does not touch WAL, but RAM. I thought
> that a checkpoint reads the information from the WAL-Files and pushes these
> information to the data files.
Not in Postgres. Updates are applied immediately to copies of the data
file pages in RAM; all that checkpoint has to do is force those buffers
out to disk.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | apb18 | 2003-07-21 14:50:45 | Re: Detoasting and memory usage |
| Previous Message | Shridhar Daithankar | 2003-07-21 14:32:27 | A doubt w.r.t WAL |