Rendered at 19:57:13 GMT+0000 (Coordinated Universal Time) with Cloudflare Workers.
nopurpose 14 hours ago [-]
> a sequential scan may push ~100GB of other data from memory (shared buffers or page cache).
Small note, if I remember correctly PostgreSQL allocates small buffer within shared_buffers for bulk reads. It is so that single sequential scan won't flush all of shared buffers content.
Similar mechanism exists for a pagecache implementation on Linux. It is divided into generations based on access patterns.
Small note, if I remember correctly PostgreSQL allocates small buffer within shared_buffers for bulk reads. It is so that single sequential scan won't flush all of shared buffers content.
Similar mechanism exists for a pagecache implementation on Linux. It is divided into generations based on access patterns.