Postgres 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.
Instant Heatmap with pg_featureserv
Use your spatial data with this lightweight web server to make an instant heatmap! Paul Ramsey sets up a demo using locations, name data, and our new container apps feature to run the pg_featureserv right inside the database.
Postgres Query Optimization: Left JOIN vs UNION ALL
See how to optimize 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.
The Vectors of Database Encryption
A high level review of the vectors of attack on databases and database encryption types including Data-At-Rest, Data-In-Transit, and Data-In-Use.
Exporter2Perfdata - 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.
Effective PostgreSQL Cluster Configuration & Management Using PGO v5.1
A review of PGO 5.1 features including rolling database restarts, pod disruption budgets, and manual switchovers/failovers.
Phases 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 two phases to database cost management, and understanding which phase you are in will help you understand your options for growth.
Crunchy Data at Upcoming Events
Stop by the Crunchy Data booth at the following events to meet the team and pick up awesome swag:
PG Day France, Montpellier, France
June 21 - 22, 2022
OpenShift Commons London, England
July 6, 2022
PGConf NYC, New York City
Sep 22 - 23, 2022
PGConf EU, Berlin
Oct 25 - 28
