Product has been added to your cart.

PostgreSQL

Home
PostgreSQL

Building SQL ConstantCare: Let’s Tune an Index in Postgres.

January 20, 2020

This week, our SQL ConstantCare® back end services started having some query timeout issues. Hey, we’re database people – we can do this, right? Granted, I work with Microsoft SQL Server most of the time, but we host our data in Amazon Aurora Postgres – is a query just a query and an index just…

Two Important Differences Between SQL Server and PostgreSQL

August 6, 2018

Brent Ozar

PostgreSQL

SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I’ve spent a lot of time writing Postgres queries lately. Here are some of the things I’ve noticed that are different. CTEs are optimization fences. In SQL Server, if you write this query: Transact-SQL With AllPosts AS (SELECT * FROM StackOverflow.dbo.Posts)…