Tag Archives: Aurora

Checkpoints logged in Aurora PostgreSQL V.15

One of the changes that came with PostgreSQL V.15 was that the configuration setting log_checkpoints had its default value changed from 0 to 1, meaning that now by default it was on. Ok, so what does this setting actually do? Well it does exactly as the name suggest, it logs all checkpoints that occur inContinue reading “Checkpoints logged in Aurora PostgreSQL V.15”

CTE’s in PostgreSQL

So today’s topic is Common Table Expressions in PostgreSQL and how they can differ to CTE’s used in MS SQL Server depending on how you set these up. So I’m a PostgreSQL newbie, coming over from the world of MS SQL Server, the first major version of PostgreSQL I worked on being V11. When comingContinue reading “CTE’s in PostgreSQL”