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