Posts about Production Postgres
Cleaning Up Your Postgres Database
Actionable steps on how to improve your Postgres database performance.
6 min read
Postgres: The Friendly Relational Member of Your Data Management Toolbox
The recent selection of Postgres as the "Database of the Year" for the third time in four years is by no means an overnight success story, but is well deserved recognition for a database decades in the making. As organizations look for the relational database of the future, Postgres is ready and waiting. We are proud to be among the leading contributors and supporters of this important movement.
3 min read
PostgreSQL 13 Benchmark: Memory Speed vs. TPS
Today I'm changing the memory speed on my main test system, going from 2133MHz to 3200MHz, and measuring how that impacts PostgreSQL SELECT results. I'm seeing a 3% gain on this server, but as always with databases that's only on a narrow set of in-memory use cases.
5 min read
PostgreSQL Benchmarks: Apple ARM M1 MacBook Pro 2020
This week Apple started delivering Macs using their own Apple Silicon chips, starting with a Mac SOC named the M1. M1 uses the ARM instruction set and claims some amazing acceleration for media workloads. I wanted to know how it would do running PostgreSQL, an app that's been running on various ARM systems for years. The results are great!
4 min read
Postgres Streaming Replication on Windows: A Quick Guide
In this blog post, we'll discuss how to set up streaming replication in Windows. Credit goes to my colleague Douglas Hunley whose blog post on setting up streaming replication on Linux served as inspiration.
5 min read
PostgreSQL Benchmarks: Apple Intel MacBook Pro, 2011-2019
Apple's Intel-based laptops are very popular among developers, and that's as true of people who work on PostgreSQL as other groups. Tomorrow, the first shipping Apple laptops running on ARM CPUs instead of Intel are expected.
3 min read
Online Upgrades in Postgres
In our previous blog post, we talked about upgrading a PostgreSQL cluster to a new major version with pg_upgrade. But in some instances zero downtime may be essential.
8 min read
Tuning Your Postgres Database for High Write Loads
As a database grows and scales up from a proof of concept to a full-fledged production instance, there are always a variety of growing pains that database administrators and systems administrators will run into.
4 min read
PostgreSQL Monitoring for App Developers: Alerts & Troubleshooting
When should you be alerted about issues in your PostgreSQL clusters? How do you troubleshoot them? What are some typical solutions?
10 min read
PostgreSQL Monitoring for Application Developers: The DBA Fundamentals
What are some PostgreSQL monitoring stats that are typically used to monitor the health of your databases?
10 min read
PostgreSQL Monitoring for Application Developers: The Vitals
What are some of the key stats to look at to ensure your PostgreSQL cluster is healthy? How can you use this stats to diagnose the problem?
9 min read
How to Setup PostgreSQL Monitoring in Kubernetes
Set up turnkey monitoring for PostgreSQL clusters running on Kubernetes using the Postgres Operator!
4 min read
Synchronous Replication in PostgreSQL
PostgreSQL has supported streaming replication and hot standbys since version 9.0 (2010), and synchronous replication since version 9.1 (2011).
9 min read
PostgreSQL 13 Upgrade and Performance Check on Ubuntu/Debian: 1.6GB/s random reads
PostgreSQL 13 was released last week. I'm excited about this one, as the more mature partitioning plus logical replication features allow some long-requested deployment architectures
6 min read
Hidden Gems of PostgreSQL 13
Which hidden gem features in Postgres 13 can have a big impact?
6 min read
PostgreSQL Node Metrics: Don't Fly Blind
Monitor your PostgreSQL container node and get host metrics with the Postgres extension pgnodemx.
13 min read
Introducing the Postgres Prometheus Adapter
To make it easier for anyone that wants to use Postgres as their backing store for Prometheus, we’re proud to announce the release of the PostgreSQL Prometheus Adapter.
5 min read
Why PostgreSQL 13 is a Lucky Release
See why PostgreSQL 13 is a lucky release as it adds features like incremental sort, parallel vacuum, and improves performance of B-tree indexes and more!
8 min read
Preventing SQL Injection Attacks in Postgres
Learn about SQL injection attacks and how to prevent them in Postgres.
8 min read
Announcing pgBackRest for Azure - Fast, Reliable Postgres Backups
Backups are a key staple of running any database. pgBackRest aims to be a fast, reliable, easy-to-use backup and restore solution with the ability to seamlessly scale to the largest databases.
3 min read
