Posts about Production Postgres
The Integer at the End of the Universe: Integer Overflow in Postgres
Integer overflow can happen if you have a sequencing data type exceeding integer limits. Jesse has a query to help you spot it and recommendations for a short term and long term fix.
7 min readPostgreSQL Unlogged Tables - Look Ma, No WAL!
Unlogged tables in Postgres can give you a big performance improvement but beware of the drawbacks. Here are some tips on how to safely give it a try.
11 min readPostgres WAL Files and Sequence Numbers
Go inside the WAL file with this in-depth look at WAL file Log Sequence Number (LSN), WAL segment positions, WAL file names, and pg_wal_switch.
7 min readExposing Postgres Performance Secrets
Craig lays out four basic things to set up today to make finding and fixing performance faster in the future.
3 min readEnums vs Check Constraints in Postgres
Enums or check constraints, which one is better? Craig breaks down why enumerated types aren’t common in Postgres.
3 min readPostgres Query Boost: Using ANY Instead of IN
Let’s show some love for the ANY Operator! Read about how to use = ANY(array) in place of the IN(list) so you can send all your parameters securely with prepared statements.
4 min readOracle to Postgres Post-Migration Improvements
Jean-Paul shows some easy tricks for changing from Orafce functions to native PostgreSQL.
6 min readExciting 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
