#248: Using pg_badplan to CREATE STATISTICS

The latest Postgres news, articles, tools, and projects.

#248 — March 21, 2018 Read on the Web Postgres Weekly Using pg_badplan to CREATE STATISTICS is a Good Plan — pg_badplan is a new extension that monitors Postgres queries and can log when Postgres statistics are not in line with the actual data. The extension looks handy for keeping your Postgres in shape. Joel Jacobson Database Constraints: The Last Line of Defense — Database constraints are a powerful tool to ensure data in your Postgres database is safe, accurate, and valid. Here you'll see some of the constraints you can put in place. Will Leinweber Go Deep into Today's Modern Data Tier to See the Root of the Problem Fast — SelectStar's advanced analytics provide in-depth query metrics such as latency, prepared statements and requests to help you see where stumbling blocks may be lurking so you can quickly and effectively troubleshoot slow queries and improve performance. SelectStar sponsor Updating a 50 Terabyte Postgres Database — A look at payment platform Adyen's evolving approach to updating their Postgres database — against the requirements and challenges posed by redundancy, uptime, and scalability. Reinier Haasjes MS Announces General Availability of Postgres on Azure — Azure Database for PostgreSQL is a fully-managed Postgres service on Azure, backed by the same enterprise infrastructure as Azure's SQL Server services. Tobias Ternstrom Tutorials Loading Terabytes of Data from Postgres into BigQuery Statsbot Fun with SQL: 'generate_series' in Postgres — generate_series is a handy function to generate data directly within Postgres. It can be useful for generating fake data, or certain reporting use cases. Craig Kerstiens Three Reasons Why VACUUM Won't Remove Dead Rows From A Table — Long running transactions, abandoned replication slots and orphaned prepared transactions. Laurenz Albe Key Things to Monitor in Postgres: Analyzing Your Workload — An overview of things to know when monitoring your database and its workload. Achilleas Mantzios How to Search For (and Destroy) Duplicate Rows in Postgres Daria Khmel Tools HeidiSQL: A Native Windows App for Database Work — If you're on Windows, HeidiSQL is a handy, open source database management tool. Supports Postgres, MySQL and SQL Server. Ansgar Becker Announcing the Release of pglogical 2.2 — A logical replication extension for Postgres. 2ndQuadrant Consulting, Remote DBA, Training, & 24/7 Support for Over 20 Years Command Prompt, Inc. sponsor

Curated by Cooperpress and Craig Kerstiens Change your email address or Stop getting this newsletter © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom