Redgate Hub

Database: PostgreSQL

All products

All topics

All levels

Redgate Test Data Manager logo

Test Data Manager: One-click deployment on AWS cloud

Deploy Redgate Test Data Manager into your own AWS account with a single CloudFormation click. Get a secure, production-ready environment for classifying, masking, and subsetting database copies in under 30 minutes, no infrastructure project required. Read more

Redgate pgNow logo

How to Identify and Fix Slow Queries in PostgreSQL

Struggling with slow queries in PostgreSQL? Learn how to spot and fix them fast, using a simple diagnostic process and the free tool pgNow. Read more

Redgate pgCompare logo

Practical PostgreSQL Schema Comparison with Redgate pgCompare

Managing PostgreSQL schema changes across environments can be challenging, especially with complex dependencies. pgCompare highlights differences between two databases and generates reliable deployment scripts. This article shows how to get started with the tool and how it simplifies everyday tasks like reviewing feature branch changes, auditing schema drift, and creating… Read more

Deploying PostgreSQL DB Changes Through AWS Developer Tools Using Flyway

Redgate Monitor logo

Understanding PostgreSQL's Cache Hit Ratio

This article explores PostgreSQL's buffer cache hit ratio (BCHR), a metric tracked by Redgate Monitor to help you assess the health and performance of your databases. By correctly interpreting this ratio and using it with other relevant memory and IO metrics, you can identify potential bottlenecks in query execution before… Read more

Redgate Test Data Manager logo

Deterministic Data Masking in Redgate Test Data Manager

Redgate Test Data Manager is designed to provide secure, anonymized, and representative copies of production databases. This article focuses on the role of deterministic data masking, transforming PII consistently across tables, even when no logical relationship exists between them, and explains how it works. Read more

Redgate Monitor logo

Current Activity for PostgreSQL in Redgate Monitor

Current Activity for PostgreSQL in Redgate Monitor provides a real-time view of queries currently running on your PostgreSQL instances. It will allow you to identify quickly any queries that are currently causing blocking and resource contention issues on an instance. Read more

Flyway logo

Managing PostgreSQL Extensions Using Flyway

Any reliable DevOps deployment process must not only deliver the right database code but also ensure that the correct conditions exist for the deployment to succeed. For PostgreSQL databases, this includes ensuring that any extensions on which the database code relies are installed, and at the correct version. Fortunately, Flyway… Read more

Flyway logo

Running Flyway Pre-Migration Checks on the Database

This article demonstrates how to run a preliminary check that issues a warning, or throws an error, if the conditions aren't met for a Flyway migration to succeed. It provides some example checks for PostgreSQL databases that use Flyway SQL callbacks to ensure the server is running the correct PostgreSQL… Read more

Redgate Monitor logo

Six Things to Monitor with PostgreSQL

This article describes six performance metrics that ought to be central to your PostgreSQL monitoring strategy. By using a tool like Redgate Monitor to track these metrics over time, and establish baselines for them, you'll be able to spot resource pressure or performance issues immediately, quickly diagnose the cause, and… Read more

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Hub

Database: PostgreSQL

Test Data Manager: One-click deployment on AWS cloud

How to Identify and Fix Slow Queries in PostgreSQL

Practical PostgreSQL Schema Comparison with Redgate pgCompare

Deploying PostgreSQL DB Changes Through AWS Developer Tools Using Flyway

Understanding PostgreSQL's Cache Hit Ratio

Deterministic Data Masking in Redgate Test Data Manager

Current Activity for PostgreSQL in Redgate Monitor

Managing PostgreSQL Extensions Using Flyway

Running Flyway Pre-Migration Checks on the Database

Six Things to Monitor with PostgreSQL

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Database: PostgreSQL

Cookies on red-gate.com