database

2 posts tagged “database”

  • 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

  • Database Notes part 2

    calendar Sep 23, 2019 · 11 min read  · database data models keys normalization clustering big data

    In the last part we outlined notions of what a database is, how a database fits inside the CAP theorem, general notions of a query and a schema, how indexes assist with faster searching, a brief overview of relational and non-relational databases, and how loose and tight coupling between a database and its front end a…


    Read More