Announcing pgwatch2 – a simple but versatile PostgreSQL monitoring tool
Yes – yes, I’m well aware that there’s already a fair amount of PostgreSQL specific monitoring tools out there – see for example see here for a non-exhaustive listing from Postgres Wiki (but there are some more, couldn’t find PgHero). But nevertheless, I was still missing something. I think the main problem that always annoyed me […]
Running production PostgreSQL systems on ARM architecture?
The title has got a question mark for a reason this time, as using ARM architecture could mean a lot of things, varying from super low power, milliwatt range, Arduinos to Raspberry Pi-s, ending with specialized supercomputing clusters. Common denominator here being still efficiency, ARM architecture is designed to be very efficient, saving money on […]
Two simple Postgres tips to kick-start year 2017
While reviewing my notes on some handy Postgres tricks and nasty gotchas, to conclude in on-site training course my “current me” again learned some tricks which an older version of “me” had luckily wrote down. So here are two simple tricks that hopefully even a lot of Postgres power-users find surprising. Disabling JOIN re-ordering by […]
Checkpoint distance and amount of WAL
Most people using PostgreSQL database systems are aware of the fact that the database engine has to send changes to the so called “Write Ahead Log” (= WAL) to ensure that in case of a crash the database will be able to recover to a consistent state safely and reliably. However, not everybody knows that […]