Wondering when to use a Materialized View or a CTE? Elizabeth has summaries, example queries, and comparisons for the most popular subquery tools.
Are you using tags in your database with some of your main database properties? Paul reviews some of the ways to store tags in a database from basic relational models to text arrays. He provides some performance tests, sample queries, and guidance on choosing the best path.
Paul has some fast and easy tricks to show you how to get time series data into nice reportable data charts. Using functions like floor(), generate_series(), width_bucket(), and date_bin() you can bin your data in groups any way you like and retrieve charts in a flash.
HypoPG is an extension to create hypothetical indexes and test if Postgres will use them. We think this tool is a good one to use in combination with our other favorites like EXPLAIN and pg_stat_statements.
Learn how to do percentage calculations in one-pass. Sample data and queries for basic use of window functions.
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
This post covers many ways to get data in Postgres including csv, json, backup files, foreign data wrappers, and generating data with queries. Examples include simple steps you can copy and reuse.
We’re excited about the MERGE command in PostgreSQL 15. We have some ideas about using it for data loading with an example use case for remote sensors.