| From: | Manfred Spraul <manfred(at)colorfullife(dot)com> |
|---|---|
| To: | Diego Montenegro <diego(dot)montenegro(at)yale(dot)edu> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Flush to Disk |
| Date: | 2004-03-28 18:21:11 |
| Message-ID: | 40671797.2010905@colorfullife.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Diego Montenegro wrote:
>Hello all,
>
>Can anyone point me to where in the code does Postgres Flush all the
>Data to disk???
>When XLogFlush is called, it only flushes the XLOG to disk, right? Does
>the entire Data get flushed at the same time as the Log?
>
>
in src/backend/storage/smgr/md.c, mdsync(): During a checkpoint, the
whole system cache is synced to the disk.
Note that checkpoints should be rare - I think every few minutes. The
xlog contains enough data to recover a transaction after a system crash,
therefore only the xlog is forced to the disk during transaction commit.
--
Manfred
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Mascari | 2004-03-28 22:07:41 | Re: Fuzzy cost comparison to eliminate redundant planning |
| Previous Message | elein | 2004-03-28 17:37:13 | Re: BUG #1118: Misleading Commit message |