This is a short summary. ↗ Open original to view full content
Grouping data into array of sums – fun with custom aggregates
from blog select * from depesz;, | ↗ original
Related
More from select * from depesz;
System views added to pgdoc.link
6 Nov 2024 |
original ↗
Checking logs for pgdoc.link I noticed that some people where searching for system views, like pg_stat_activity, or pg_stat_all_tables in Pg 9.3. Now, these will work. This increased total number of known keywords from 1840 to 1883. Not much, but it's a progress 🙂
Waiting for PostgreSQL 18 – Add SQL function array_reverse()
5 Nov 2024 |
original ↗
On 1st of November 2024, Michael Paquier committed patch: Add SQL function array_reverse() This function takes in input an array, and reverses the position of all its elements. This operation only affects the first dimension of the array, like array_shuffle(). The implementation structure is inspired by array_shuffle(), with a subroutine...
New way to search PostgreSQL documentation
29 Oct 2024 |
original ↗
PostgreSQL documentation is, generally speaking, great. But it isn't the easiest thing to search in. Over the years I memorized urls to certain docs, but there is a limit to it. What's more, there are certain inconsistencies. For example – most pages that describe program have name that starts with app-. But not all. Some … Continue reading "New...
Case study: optimization of weirdly picked bad plan
28 Oct 2024 |
original ↗
We recently hit an interesting case where planner picked wrong plan. Kinda. And figured it could be used to show how to deal with such cases. So, we have some databases on PostgreSQL 14 (yes, I know, we should upgrade, but it is LONG project to upgrade, so it's not really on the table now). … Continue reading "Case study: optimization of weirdly...
SQL/JSON is here! (kinda “Waiting for Pg 17”)
11 Oct 2024 |
original ↗
Amazing. Awesome. Well, but what is it? We could store json data in Pg since PostgreSQL 9.2 – so it's been there for over 12 years now. How is the new shiny thing different? What does it allow you to do? Let's see if I can shed some light on it… For starters: SQL/JSON is … Continue reading "SQL/JSON is here! (kinda “Waiting for Pg 17”)"