performance

1 post tagged “performance”

  • Combined (Vectorized) I/O in PostgreSQL 17

    calendar Sep 28, 2024 · 5 min read  · postgresql database performance io

    PostgreSQL, like most databases, operates using fixed-size pages of data, each 8 kilobytes in size. When reading data, the database fetches these pages from disk. Background In a database system, a page is the fundamental unit of data storage and retrieval. Most databases, including PostgreSQL, organize data into fixe…


    Read More