Posts about Production Postgres
Exciting updates for Crunchy Postgres: Enhancements to TLS, Firewall Management, Monitoring and More
We just released a new version of Crunchy Postgres. Packed with security, access management, and monitoring updates. Giving you more flexibility and options for running production Postgres.
4 min readPostgres Data Flow
What happens when you query Postgres? Data can actually come from many different places like the application cache, buffer cache, and even down into the physical disk cache. This post surveys the data storage and flow of Postgres data.
7 min readGenerate Unlimited Crypto Using Postgres!
Just kidding. This is not crypto mining tutorial! It is a very practical description of using pgcrypto for encrypting and decrypting data inside your Postgres database.
9 min readPostgres Migration Pitstop: Collations
Checking on your collations is a must have stop on your migration path. You might just run a quick check and be on your way or you might need to add a few more steps to your cutover plans.
6 min readPostgres Locking: When is it Concerning?
Seeing locks in your Postgres monitoring but don't know what it means? David takes a look at locks and what to take into consideration.
8 min readPhases of Database Growth and Cost
When it comes to database performance, many think they are solving technical problems, but are solving a money problem. There are 2 phases to database-cost management, and understanding which phase you are in will help you understand your options for growth.
6 min readExporter2Perfdata - Connecting Postgres Monitoring Tools
Crunchy Data is excited to release a new open source tool, Exporter2Perfdata. This connects Prometheus Exporters with Icinga2/Nagios. This also allows pgMonitor users to connect monitoring information from Prometheus to Icinga2 and Nagios.
3 min readPostgres Query Optimization: LEFT JOIN vs UNION ALL
David optimizes a slow query by splitting up a left join into two calls and using UNION ALL to combine them. The proof is in the pudding.
6 min readPostgres Traceability: Use SQL Comments Like a Stacktrace
Which of my applications ran this SQL statement? Use SQL comments to track which application ran which queries.
4 min readDemystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
9 min readFive Tips For a Healthier Postgres Database in the New Year
Craig's year end wrap-up of 5 things you can do for a healthier Postgres database next year.
5 min read
Patroni & etcd in High Availability Environments
A deep dive into Patroni, etcd, and the etcd consensus protocol to diagnose common communication and system issues.
13 min read
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
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
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
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
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
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
