by Neha Korukula | Apr 3, 2024 | Insight for DBAs, PostgreSQL
A Foreign Data Wrapper (FDW) is a feature in database management systems that can communicate with an external data source and access data without physically moving the data on a working local database.PostgreSQL implements portions of the SQL/MED specification,... by Neha Korukula | Apr 1, 2024 | Insight for DBAs, PostgreSQL
This blog was originally published in July 2023 and was updated in April 2024.Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. In this article, we’ll discuss how to effectively use... by Neha Korukula | Dec 1, 2023 | Insight for DBAs, PostgreSQL
The PostgreSQL partition manager pg_partman is an open source extension widely supported and actively maintained by the PostgreSQL community. pg_partman is an extension that streamlines the creation and management of table partition sets, supporting both... by Neha Korukula | Sep 27, 2023 | Insight for DBAs, PostgreSQL
PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community.pg_partman creates and manages both time-based and serial-based table partition...