Postgres Surprise #4: Pricing
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…
Postgres Surprise #3: Stored Procedures and Functions
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.…
Postgres Surprise #2: Vacuuming Out Old Row Versions
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…
Get Postgres Training For Your Whole Company for $1995.
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…
Postgres Surprise #1: There’s No Clustered Index.
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…
Announcing the Box of Tricks v0.1 with check_indexes and drop_indexes
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,…
Why I Started Using Postgres (And You Might Too)
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,…
Quick Comparison Review: DBeaver vs DataGrip vs Visual Studio Code
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…
Announcing Fundamentals of Index Tuning
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…
Why You Don’t Find Start-to-Finish Postgres Server Performance Tuning Guides
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…