PostgreSQL Buffer Manager (cont)
Buffer pool consists of:
BufferDescriptors (i.e. directory)
- shared fixed array of
NBuffers x BufferDesc
BufferBlocks (i.e. frames)
- shared fixed array of
NBuffers x buffers (each BLCKSZ bytes)
Buffer = index in above arrays
- indexes: global buffers
1..NBuffers; local buffers negative
Size of buffer pool is set in postgresql.conf, e.g.
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}