Bookmarks (31) clear filters

▶  How a DBA Used Postgres to Discover 40K Voters Purged by Mistake — A long-time database administrator was running queries on voter data to learn how to use Postgres and stumbled over a significant voter purge error. (The part mentioning Postgres is at around 4 minutes in.)

▶  The State of (Full) Text Search in Postgres 12 — The audio isn’t great but nonetheless this is a great primer to different text search techniques in Postgres starting from the absolute basics (e.g. LIKE and regexp_match) and moving on to Postgres’s full-fat FTS features.

▶  Postgres Performance Tuning and Optimization — An hour-long talk that focuses on tuning configuration settings (both in Postgres and on Linux generally) and what things they each affect.

▶  Using PEM to Improve Performance in Postgres: The Postgres Tuning Wizard and Performance Diagnostics — An hour-long webinar running through how to use EDB’s Postgres Enterprise Manager (PEM) GUI. (Note: the audio is a bit muffled generally.)

▶  What Developers Are Doing with Postgres and MySQL On Azure — A 30 minute talk and discussion from last week’s virtual Microsoft Build conference. Quite high level.

▶  Discussing Index Corruption in Postgres — Two developers at EnterpriseDB discuss database corruption and how corrupt indexes are not always as obvious as corrupt tables.

▶  Easy And Correct High Availability Postgres with Kubernetes — A 50 minute talk from PostgresOpen 2019 that goes all the way ‘from containers up’ until actually doing stuff with Postgres.

▶  Azure Arc: Bring Hyperscale PostgreSQL to On-Premises and Multi-Cloud — Azure Arc is a still in-preview approach to deploying Azure services ‘anywhere’ across on-premise, edge, and multicloud environments.

▶  Digging into Postgres at a Low Level: Stay Curious — A ~40 minute talk from last year that, sadly, we forgot to include at the time. It goes deep into exploring how to use tools like strace and gdb to troubleshoot intricate performance issues. Most of you will never need to do these things, but it’s useful to know it’s possible.

▶  The State of (Full) Text Search in Postgres 12 — A fantastic 50 minute talk from FOSDEM covering the ins and outs of Postgres 12’s full text search capabilities. The audio is a little clippy here and there but there’s a lot of great stuff packed into this talk and the (very) detailed slides are here.

▶  'Nothing Compares To VACUUM': A Postgres Song — A Postgres-themed cover of Sinead O’Connor’s Nothing Compares to You but with a GRANT flavored twist.

▶  Why Developers Love Postgres — A just released, high level talk about why Postgres is a great database, including a section about how a department at Chevron migrated from Oracle to Postgres.

▶  Innovations to Boost Productivity with Azure-Managed Postgres — One for anyone considering running Postgres (or MySQL or MariaDB) on Azure.