Bookmarks (1085)

Query Optimization with pg_stat_statements — pg_stat_statements is a module that tracks planning and execution statistics for SQL queries to help you optimize them.

An Interview with Takayuki Tsunakawa — The latest in the line of “PostgreSQL Person of the Week” interviews is with a developer who’s been working on Postgres for almost twenty years, leads the open source team at Fujitsu, and maintains the Postgres ecosystem wiki.

Fauna - All the Goodness of Postgres, Without Operational Bottlenecks — Fauna combines the safety of Postgres with schema flexibility, modern capabilities and limitless scale. Learn more...

Deep Postgres Thoughts: Resistance to Containers is Futile — A common ‘complaint’ about containers is how they’re not well suited for running database systems, but it’s a complicated and nuanced matter to navigate and one you should at least be aware of.

pgBadger 11.5 Released: A Fast Postgres Log Analyzer — Get info about queries, running time, server info, and more. 11.5 adds support for anonymization of numeric values for sensitive use cases, as well as more info about session idle time. They’re a bit out of date, but here’s an example of the sort of report it can generate.

TimescaleDB 2.1 Released — A popular time-series oriented database on top of Postgres. 2.1 adds Postgres 13 support.

Approaches to Fuzzy Name Matching — Neither the data entry process or how people’s memories work is perfect, so sometimes it can be helpful if a system will return data that’s like what we’re searching for.. such as “Jim Harrington” for a search for “Jimmy Arrington.” This post looks at a few approaches Postgres offers for more “fuzzy” searching.

Using Postgres to Do a Regex-Based Search Over 10,000 GitHub Repositories — Empirical measurements from experiments in using Postgres to index and search over 10,000 popular GitHub repositories using pg_trgm (trigram matching functions) on a 2019 MacBook Pro.

Build Internal Apps (Faster) on Top of Postgres — Connect to Postgres (or anything with an API). Design your app with 50+ drag-and-drop React components. Write JavaScript anywhere.

Faster Data Migrations in Postgres — An exploration of things to consider when looking at different ways to speed up your database migrations.

How to Create a Trigger — Triggers are often one of the first things you encounter if you move from using Postgres as a naive data store to a fully fledged database, and they make it possible for Postgres to respond to database related events in real time (ideal for auditing, updating external indexes, converting values, etc.)

PostgreSQL 13.2, 12.6, 11.11, 10.16, 9.6.21, and 9.5.25 Released — A suite of updates to Postgres to fix two security vulnerabilities. This is also expected to be the final 9.5 branch release ever, so upgrading if you’re on 9.5 now becomes even more important.

5 Ways to Get More from PostgreSQL — PostgreSQL is a top open source database management system (DBMS) choice for business today. This eBook explores 5 important tactics to help IT Managers and DBAs better manage PostgreSQL deployments and ultimately get the most out of Postgres.

Implementing a Generic REDUCE Aggregate Function with SQL — A fun bit of SQL spelunking here for arbitrarily reducing a collection of data. If you want to learn something about SQL today, this is the article for you.

On ANALYZE and Optimizer Statistics — A (very) quick, practical look at how Postgres handles queries, tries to find the best execution plan for them, and the statistics that help the optimizer do this.

Where Are The Postgres Config Files? — Rather than poking around your filesystem, you can just ask Postgres itself to tell you where various config files are.

Babelfish: The Elephant in The Room? — Last year, AWS announced Babelfish, a project to provide a SQL Server compatible endpoint for PostgreSQL and that will be open sourced this year. Will an open source version easily integrate with Postgres though? Not exactly, and that’s the problem examined here.