Posts about Production Postgres
-3.png)
Postgres 14: It's The Little Things
Today I wanted to call some extra attention to those little things, the ones that don't get the spotlight, but simply make a developer's life better.
5 min read-1.png)
Insert-Only Tables and Autovacuum Issues Prior to PostgreSQL 13
If you have insert-only tables in a version of PostgreSQL earlier that 13, you could benefit from running a regularly scheduled VACUUM.
5 min read
PostgreSQL on Linux: Counting Committed Memory
By default Linux uses a controversial (for databases) memory extension feature called Overcommit. How that interacts with PostgreSQL is covered in the Managing Kernel Resources section of the PG manual.
6 min read
Better Range Types in Postgres 14: Turning 100 Lines of SQL Into 3
Almost a decade after range types were introduced, Postgres 14 makes it easier to write "boring SQL" for range data. Meet the "multirange" data type.
5 min read.png)
Using Kubernetes? Chances Are You Need a Database
Whether you are starting a new development project, launching an application modernization effort, or engaging in digital transformation, chances are you are evaluating Kubernetes. If you selected Kubernetes, chances are you will ultimately need a database.
4 min read.png)
Choice of Table Column Types and Order When Migrating to PostgreSQL
An underappreciated element of PostgreSQL performance can be the data types chosen and their organization in tables. For sites that are always looking for that incremental performance improvement, managing the exact layout and utilization of every byte of a row (also known as a tuple) can be worthwhile.
9 min read.png)
Postgres is Out of Disk and How to Recover: The Dos and Don'ts
The ultimate goal for any unplanned database interruption is to reduce data loss. So the advice here is aimed at someone in a production situation prioritizing minimizing data loss.
12 min read.png)
Introducing pgBackRest Multiple Repository Support
The pgBackRest team is pleased to announce the introduction of multiple repository support in v2.33. Backups already provide redundancy by creating an offline copy of your PostgreSQL cluster that can be used in disaster recovery.
5 min read
Announcing Google Cloud Storage (GCS) Support for pgBackRest
Today we're announcing Crunchy Bridge support for Managed Postgres on Google Cloud. With Crunchy Bridge you can now have the same great PostgreSQL experience on any cloud and seamlessly migrate between cloud vendors as you see fit.
2 min read.png)
Database Terminology Explained: Postgres High Availability and Disaster Recovery
What follows is a summary of conversations I've had with customers on how to think about key tenants of database management, high availability and disaster recovery.
Deep PostgreSQL Thoughts: The Linux Assassin
When Linux detects that the system is using too much memory, it will identify processes for termination and, well, assassinate them. The OOM killer has a noble role in ensuring a system does not run out of memory, but this can lead to unintended consequences.
11 min read.png)
The Answer is Postgres; The Question is How?
Deciding to use Postgres is a great start, we like to think it’s the right start. As to how best to deploy it, you have a number of options.
7 min read.png)
Change Data Capture in Postgres With Debezium
A step-by-step guide for how to setup PostgreSQL change data capture with Debezium and Apache Kafka.
9 min read-1.png)
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.png)
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
