Redgate Hub

All products

All topics

PostgreSQL (9)

How to (9)

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

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

Flyway logo

Getting an Overview of Changes to a PostgreSQL Database using Flyway

How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts. Read more

Flyway logo

Getting Started with Flyway Migrations on PostgreSQL

Use PowerShell to run some Flyway migration scripts that will build, fill and modify a PostgreSQL database. 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 Assistant

Redgate Hub

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

Managing PostgreSQL Extensions Using Flyway

Running Flyway Pre-Migration Checks on the Database

Six Things to Monitor with PostgreSQL

Getting an Overview of Changes to a PostgreSQL Database using Flyway

Getting Started with Flyway Migrations on 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 Assistant

Cookies on red-gate.com