debian

This tag is associated with 3 posts

Postgres Checkpoint Followup and Collation Visualization and Codex Luna

Posted by Jeremy ⋅ August 12, 2026 ⋅ Leave a comment

My previous article talked about the checkpoint happiness hint: You probably should not change the checkpoint_timeout setting from its default of 5 minutes. Checkpoint Followup Questions A good follow-up question was raised: can an HA replica can save you from downtime if you want to set a large checkpoint_timeout? It’s true that Postgres allows promoting … Continue reading →

Collation Torture Test versus Debian

Posted by Jeremy ⋅ May 22, 2025 ⋅ Leave a comment

Collation torture test results are finally finished and uploaded for Debian. https://github.com/ardentperf/glibc-unicode-sorting The test did not pick up any changes in en_US sort order for either Bullseye or Bookworm 🎉️ Buster has glibc 2.28 so it shows lots of changes – as expected. The postgres wiki had claimed that Jessie(8) to Stretch(9) upgrades were safe. … Continue reading →

Waiting for Postgres 18 – Docker Containers 34% Smaller

Posted by Jeremy ⋅ April 7, 2025 ⋅ Leave a comment

On February 25, 2025 Christoph Berg committed the patch: This closed Debian bug 927182 which had been opened in April 2019 by Laurence Parry. That bug had raised concerns over the significant size increase of adding LLVM as a requirement to support Postgres JIT functionality. Postgres supports packaging LLVM as a separate optional package without … Continue reading →