SQLpassion BLOG

Developers coming from SQL Server often approach PostgreSQL with the assumption that spatial functionality will look and behave more or less the same. After all, both systems expose geometry and geography types, both support distance calculations, and both offer spatial indexes. That assumption is only partially correct. While PostgreSQL with PostGIS covers everything SQL Server …

Spatial Data with PostGIS in PostgreSQL + read more

When SQL Server professionals start working seriously with PostgreSQL, most of the learning curve feels comfortable. Tables behave as expected, transactions are familiar, and B-tree indexes look reassuringly similar to what you have used for years in SQL Server. Then you encounter BRIN indexes. At first glance, they seem almost reckless: no row pointers, no …

BRIN Indexes in PostgreSQL + read more

If you come from SQL Server (like in my case), PostgreSQL indexing can feel familiar at first – B-tree indexes exist, composite indexes exist, covering indexes exist. And then you run into queries like this: or this: At that point, most SQL Server developers ask two questions: What are these operators? Why does PostgreSQL need …

GIN Indexes in PostgreSQL + read more