👩💻 Join our community of thousands of amazing developers!
How Postgres handles data storage of oversized attributes.gojek.jobsPostgreSQL is a powerful open source object relational database system, which has been widely adopted as a primary option for many applications.In this post, we’ll take a look at how Postgres handles database storage and caching.First, the basicsPostgreSQL database loads all data into page cache, which is different from OS Paging. A page cache of size 8KB is used for storing tuples, indexes, and Query Execution plans. Even the W...