Since the late 1990s, I worked with Microsoft SQL Server. My employers over the years had standardized on MSSQL for a variety of reasons: It was well-integrated with Microsoft Visual…
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 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…
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…
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…
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,…
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,…
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…
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…
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…