Skip to content

Latest commit

 

History

History
8 lines (5 loc) · 586 Bytes

File metadata and controls

8 lines (5 loc) · 586 Bytes

buffer cache

The buffer cache is a portion of memory allocated to store copies of database pages (blocks) that are read from or written to the disk. When a database page is needed for a query or an update, PostgreSQL first checks if the page is already in the buffer cache. If it is, the operation can proceed without accessing the disk, resulting in faster performance.

也就是说, upadte或者delete的数据,首先会在buffer cache中进行操作,然后再合适时机写入到磁盘中。 1

so, when write into disk? read WAL