#306 — May 22, 2019 |
Postgres Weekly |
Don't Do These Things in Postgres — An interesting page on the official Postgres wiki that attempts to round up a variety of ‘common mistakes’ in using Postgres, such as “Don’t use Postgres Wiki |
PostgresLondon 2019 Schedule Out Now 🇬🇧 🐘 — Join us in London for the evolution of PGConf UK to learn more about recent achievements & exciting future developments in PostgreSQL. You can also participate in hands-on training with experts covering: Performance Tuning, PostgreSQL Security, & Multi-master Replication. 2ndQuadrant PostgreSQL Events sponsor |
Using Luca Ferrari |
A Look at RUM Indexes — A few weeks ago we linked to an amazing introduction to GIN indexes, now the same author is back with a similar deep dive into the world of RUM, essentially an extended type of GIN index for specific use cases. It’s not a built-in index type, however. Egor Rogov |
Abusing Laurenz Albe |
A Health Check Playbook for Your Postgres Database — As data comes in and queries are executing, the composition of your database will change - here, Craig suggests some things you can do frequently to ensure the long term health of your database. Craig Kerstiens |
Getting The Most Out of Your Postgres Indexes — Quick examples and tips around covering indexes, partial indexes, multi-value indexes, and more. RapidLoop |
Driving Time-Series Database Performance with PostgreSQL & TimescaleDB — Learn how ClusterControl can monitor, manage, and ensure the performance of your time-series data. Severalnines sponsor |
Considering Multi-Column Indexes — A look at some of the downsides to multi-column indexes and how to consider if they fit your use case. David Conlin |
How to Deploy Postgres to a Docker Container with ClusterControl Sebastian Insausti (Severalnines) |
pgBackRest: A Year of Growth for a 'Great Backup Solution' — “pgBackRest addresses many of the must-have features that you’ll want to look for in a PostgreSQL backup solution.” Jobin Augustine |
|
|