Introducing pgpool-II, a middleware product which brings high availability for enterprise database, outlining the main features and key points of the setup.
Highlighting the mechanism and PostgreSQL structure of streaming replication, which replicates database clusters in batch.
High Availability line 2
This article explains how PostgreSQL Foreign Data Wrappers can access various external data sources such as Oracle, MySQL, SQL Server, and MongoDB, among others.
This is the first part on our discussion of how to access Oracle databases using PostgreSQL's Foreign Data Wrapper oracle_fdw.
Have a look at the most frequently used open source extensions enhancing PostgreSQL functionalities, and what they are used for.
Describing stored procedures, added in PostgreSQL 11, with definition and execution samples.
PostgreSQL central line 2
This article explains partitioning, the method for storing data in divided tables, based on declarative partitioning.
Explaining the mechanism of pruning, wise join, wise aggregation, that can enhance partitioning performance.
Performance line 2
Read our most recent articles regarding all aspects of PostgreSQL and Fujitsu Enterprise Postgres.