Rollback behavior on a statement error in transaction block
Summary: In this article, we will learn the rollback behavior on a statement error in transaction block, and the difference between PostgreSQL and Oracle.
Transactional DDL in PostgreSQL: Database Comparison
Summary: In this article, we will learn the transactional DDL in PostgreSQL, and differences with other popular databases.
PostgreSQL Subtransaction Problem: Subtransaction cache overflow
Summary: In this article, we will know a subtransaction problem in PostgreSQL: subtransaction cache overflow.
PostgreSQL Subtransaction Problem: Transaction ID Growth
Summary: In this article, we will know a subtransaction problem in PostgreSQL: transaction id growth.
PL/pgSQL Exception and Subtransactions
Summary: In this article, we will learn what’s the relationship between PL/pgSQL exception and subtransactions.
Trace PostgreSQL Query Processing Internals
Summary: In this article, we will trace the internals of PostgreSQL query processing.
What is Oracle GoldenGate for PostgreSQL supported?
Summary: This article introduces you what data types, objects, and operations supported in Oracle GoldenGate for PostgreSQL.
Configuring Oracle GoldenGate for PostgreSQL
Summary: This article lists details about configuring Oracle GoldenGate for PostgreSQL.
Planner statistics for indexed expressions
Summary: PostgreSQL is gathering statistics for indexed expressions, in order to make good choices of query plans.
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.