Tag: pluggable storage api

Enterprise PostgreSQL Solutions

How PostgreSQL Inserts A New Record With The help of Table Access Method API and Buffer Manager

1. Introduction This blog talks about a high level description of the mechanism behind PostgreSQL to execute an INSERT query. This process involves many steps of processing before the data is put in the right place. These process normally involves several catalog cache lookup to determine if the destination table exists or several checking on…
Read more

Approaches to Achieve in-Memory Table Storage with PostgreSQL Pluggable API

1. Introduction Recently, I have had an opportunity to perform some in-depth feasibility study in-memory table using PostgreSQL’s pluggable storage API. The pluggable storage API was introduced Since PostgreSQL v12 and it allowed custom table storage Access Methods (AM for short) to be developed. Some famous examples include zheap from EDB, which aims to store…
Read more