Data linkage

Linking to foreign data using foreign data wrappers

This article explains how PostgreSQL Foreign Data Wrappers can access various external data sources such as Oracle, MySQL, SQL Server, and MongoDB, among others.

How to link to Oracle databases using oracle_fdw (part 1)

This is the first part on our discussion of how to access Oracle databases using PostgreSQL's Foreign Data Wrapper oracle_fdw.

How to link to Oracle databases using oracle_fdw (part 2)

This article concludes our discussion of the use of PostgreSQL's foreign data wrapper oracle_fdw, and how to use it more effectively.

High Availability

What is streaming replication, and how can I set it up?

Highlighting the mechanism and PostgreSQL structure of streaming replication, which replicates database clusters in batch.

Setting up failover and recovery on a streaming replication configuration

Overview of failover and recovery measures available when using streaming replication.

How to implement High Availability using pgpool-II

Introducing pgpool-II, a middleware product which brings high availability for enterprise database, outlining the main features and key points of the setup.

Coming soon

PostgreSQL central

Introduction to frequently used open source extensions

Have a look at the most frequently used open source extensions enhancing PostgreSQL functionalities, and what they are used for.

Using stored procedures in PostgreSQL

Describing stored procedures, added in PostgreSQL 11, with definition and execution samples.

Coming soon

Performance

What are the partitioning types available in PostgreSQL, and how should I choose one?

This article explains partitioning, the method for storing data in divided tables, based on declarative partitioning.

 

Improving database performance using partitioning — step-by-step

Explaining the mechanism of pruning, wise join, wise aggregation, that can enhance partitioning performance.

 

Coming soon

Read our Latest Blogs

Read our most recent articles regarding all aspects of PostgreSQL and FUJITSU Enterprise Postgres.