Hello all,in src/backend/storage/smgr/md.c, mdsync(): During a checkpoint, the whole system cache is synced to the disk.
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?
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
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
