PostgreSQL Blog

PL/pgSQL Exception and Subtransactions

Summary: In this article, we will learn what’s the relationship between PL/pgSQL exception and subtransactions.

Continue reading

Trace PostgreSQL Query Processing Internals

Summary: In this article, we will trace the internals of PostgreSQL query processing.

Continue reading

What is Oracle GoldenGate for PostgreSQL supported?

Summary: This article introduces you what data types, objects, and operations supported in Oracle GoldenGate for PostgreSQL.

Continue reading

Configuring Oracle GoldenGate for PostgreSQL

Summary: This article lists details about configuring Oracle GoldenGate for PostgreSQL.

Continue reading

Planner statistics for indexed expressions

Summary: PostgreSQL is gathering statistics for indexed expressions, in order to make good choices of query plans.

Continue reading

Planner statistics in PostgreSQL

Summary: Planner statistics play a key role in improving the performance of the database. The query planner uses the statistical data to generate efficient run plans for queries. The purpose of this post is to explain the types of statistics in PostgreSQL and how to read and understand them.

Continue reading

Use Navicat to compare and synchronize structure

Summary: Navicat compares objects between two databases and/or schemas and states the differences in structure, and synchronize the table structures and other objects.

Continue reading

Use Navicat to compare and synchronize data

Summary: Navicat provides the ability for data in different databases and/or schemas to be kept consistent so that each repository contains the same information.

Continue reading

PostgreSQL Backward Compatibility

Summary: Backward compatibility of database versions is critical, as it directly impacts the availability, continuity, and overall efficiency of business systems, and is necessary for the success of a database product. When you get used to using some successful database products, you may not feel that they exist, because it has become like air and water, making you feel that database products are supposed to be the way they are. However, if you choose to use a bad database product, you will feel like you’re always running into problems because of the lack of backward compatibility of the versions.

Continue reading

Development culture in PostgreSQL community

Summary: The PostgreSQL community is characterized by a unique development culture that emphasizes collaboration, transparency, and community-driven contributions.

Continue reading