Background Writer (bgwriter)功能:负责定时写 shared buffer cache 中的 dirty shared buffers好处:a. 减少系统flush shared buffers到硬盘(已经被bgwriter做了)b. 在checkpoint中,不会看到I/O的突然性暴增,因为dirty buffers在背景中已经被flush进硬盘坏处:因为一直定时在背后flush disk,会看到平均硬盘I/O怎加(好过checkpoint时I/O暴增)设定:bgwriter_delay:sleep between rounds。 default 200(根据机器, Read More
posted @ 2013-04-22 11:05 立春了 Views(814) Comments(0) Diggs(0) Edit