Bookmarks (29) clear filters

▶  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.

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

▶  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.

▶  8 Talks from pgDay Paris 2019 — pgDay Paris was a one day Postgres conference in France’s biggest city last March. The videos of the sessions are now available. This year’s edition is coming on March 26, 2020. All of the talks are worth checking out, but these may be of particular technical interest:

▶  How to use MongoDB and PostgreSQL in GraphQL — A demonstration of bringing various databases together (the choice of MongoDB and Postgres are reasonably arbitrary here) using the GraphQL query language, Apollo Server, and Node.js.