Background Wanted to intentionally create free pages in a PostgreSQL table. Outline DDL Create a new table ( dateRange) DML Add data to table ( dateRange.insert.sql ) Update data in table ( dateRange.update.series.sql ) Delete data from table ( dateRange.delete.series.sql ) Metadata Extension Review Free Space ( pg_freespacemap.sql ) Code DDL Create Table Add Data Delete … Continue reading PostgreSQL :- Create free pages in Table
Background As we used the pg_buffercache extension in our last post, let us talk about how we register it. Extensions Available Extensions pg_catalog.pg_available_extensions Outline Available extensions are exposed via the pg_catalog.pg_available_extensions view. Columns name Name of the extension default_version The default version number This is the version of the extension that is installed when "CREATE … Continue reading PostgreSQL :- Extensions :: pg_buffercache
Background Of course, we rarely have enough memory. And, so we have to remain vigilant as to what objects are squabbling over memory. Code Extension :- pg_buffercache Registration Pleas ensure that pg_buffercache is registered. Registration steps are outlined here. Outline Get Buffer Size Object :- pg_settings name => shared_buffers setting => value Get Objects … Continue reading PostgreSQL :- What is in our buffer cache ?