If multiple users are querying the same regions of the same tables, does each process have to read the same blocks, or can they share ("oh look, some other process has already read into memory some of the data blocks I need, so I'll just share those buffers")?
All data pages are manipulated while in the shared memory area. The size of which is controlled by the “shared_buffers” configuration option.
David J.
