Diego Montenegro wrote:
>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.
In response to
pgsql-hackers by date
|Next:||From: Mike Mascari||Date: 2004-03-28 22:07:41|
|Subject: Re: Fuzzy cost comparison to eliminate redundant planning|
|Previous:||From: elein||Date: 2004-03-28 17:37:13|
|Subject: Re: BUG #1118: Misleading Commit message|