I’ve worked with Microsoft SQL Server since the late 1990s. In that world, almost every table has what’s called a clustered index, which we think of as the data itself. The table’…| Smart Postgres
Let’s start with the summary and work backwards: If you’re porting code from Microsoft SQL Server to Postgres, the big surprises are that Postgres stored procedures don’t return result sets. In Postgres, if you wanna return rows, you use a function – which you can also do in Microsoft SQL Server, of course. It’s one...| Smart Postgres
In my first Postgres Surprise post, we talked about the fact that Postgres’s tables are heaps: unsorted copies of the data, as opposed to many other databases that use sorted (aka clustered) indexes that are continuously sorted in real time. We said the heap approach makes sense for Postgres because it’s always used multi-version concurrency...| Smart Postgres
Management has flat-out told you that you gotta learn Postgres. Your developers, business intelligence folks, DBAs, they’ve all been told that you need to start using Postgres to cut costs – but your apps and reports still have to go fast. Switching to Postgres is harder than it looks. The query plans, indexes, and database...| Smart Postgres
Back in 2017, I started designing a new application. At that point, almost all of my database experience focused on Microsoft SQL Server and its variations – Azure SQL DB, Amazon RDS SQL Serv…| Smart Postgres
Say hello to the first official release of the SmartPostgres Box of Tricks! First up is check_indexes, a script that lists things like index types, definitions, sizes, last vacuum dates, dead tuples, and more. The warnings columns will also tell you if autovacuum isn’t keeping up, statistics are way out of date, and more: Next...| Smart Postgres
When you’re writing and tuning Postgres queries, what visual editor is the easiest to use? In this video, we’ll check out a few popular tools: DataGrip, DBeaver Community, and Visual St…| Smart Postgres
When you’re a Postgres performance tuner, tuning starts in one of two ways: Someone brings you a query and asks you to make it go faster, or Someone brings you a server and asks you to make i…| Smart Postgres
You’re comfortable getting the data you want out of Postgres, but your queries don’t come back as quickly as you’d like. You don’t really wanna make any app code changes – you just want everything to go faster, now. Good news! You can grab my Fundamentals of Index Tuning for Postgres class: In this class,...| Smart Postgres
I’ve been working with Microsoft SQL Server since the late 1990s, and about a decade ago, I started working with Postgres. I just recently started teaching Postgres index tuning, and one thing comes up all the time. I really wish I could tell Postgres which index to use for a query. In Microsoft SQL Server,...| Smart Postgres