Issue 365 - Recreating a location based social network with Postgres (11)

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

Recreating YikYak with PostgreSQL — YikYak was an anonymous social network that used your location to show you posts 5km around you (we can’t see how that could possibly cause problems.. 😂) and you can recreate the underlying principle of its operation using Postgres’s geographical coordinate support.

pgwatch2 v1.8.0 Released — pgwatch2 is a popular Postgres monitoring tool and it now has Pgpool-II, Postgres 13 and TimescaleDB metrics storage support.

Partitioning a Large Table Without a Long-Running Lock — You’ve got a huge table, you need to partition it, but you need that table to remain available to your app.. what do you do? Andrew Dunstan has a recipe to follow.

Getting More Performance for LIKE and ILIKE Statements — Our tip of the week (below) covers pattern matching and LIKE, but what if it’s not enough and you want to speed up performance? There are solutions!

GROUPING SETS and NULL Values — Our tip in issue 359 was about grouping sets, a way to perform grouping within a query that’s more complex than simple GROUP BY column can do. Bruce looks at the relationship between using GROUPING SETS and null values.

Representing Dates, Times and Intervals in Postgres — Postgres comes with a bunch of built-in date and time related data types. But why should you use them over strings or integers? Here’s an overview looking at the why, plus advice on how to do so effectively.

💻Live Webinar: 5 Ways to Improve Postgres Insert Performance — Join us on Aug 19 to learn five simple, yet powerful, techniques to supercharge your PostgreSQL ingest performance - plus live demos and pro tips for each tactic.

Examining the Postgres Catalog with Python — Mark Ryan looks at how to get the most out of database metadata - by writing a program to automatically extract the information held within.

Real-Time Postgres Performance Monitoring — Collect out-of-the-box and custom PostgreSQL metrics and correlate them with data from your distributed infrastructure, applications, and logs. Gain real-time performance insights and set intelligent alerts with Datadog. Start a free trial.