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
