Tag Archives: PostgreSQL

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”

What Tech Books am I reading?

Well folks today is a less technical post as I discuss the books that I have read over the last 12 months and those that I hope to get through in the coming year. As we approach the end of the summer here in Ireland, I always think its a good time to review theContinue reading “What Tech Books am I reading?”

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”