Smart Postgres News and Techniques 2024 Vol 8
If you write queries – and forgive me, because I know that sounds like everyone, and that’s because it is – then you need to know how Postgres handles nulls.…
Smart Postgres.
Faster queries. Cheaper cloud bills.
Free weekly bulletin with:
- The Technique of the Week
- The latest news on PostgreSQL
- Tips on AWS, Azure, hosting
Finding Sister Locations to Help Each Other: Answers & Discussion
This week’s query exercise asked you to find two kinds of locations in the Stack Overflow database: Locations populated with users who seem to be really helpful, meaning, they write…
Query Exercise: Find Sister Locations to Help Each Other
For this week’s Query Exercise, let’s start by taking a look at the Users table to see what we’re dealing with: PgSQL select u.location, count(*) as population, avg(u.reputation) as AvgReputation…
Finding Long Values Faster: Answers & Discussion
Our challenge from last week was that the developers were complaining about a slow query in the Stack Overflow database that wasn’t as fast as they’d like. PgSQL select *…
Smart Postgres News and Techniques 2024 Vol 7
The best single-page guide to query tuning that I’ve ever seen, for any database platform, dropped this week from Francesco Tisiot of EverSQL. It’s one hell of a long page,…