RSSAmplifier

Blog

Benoit Tigeot's blog

Ruby on Rails, PostgreSQL, and more.

benoittgt.github.io ↗RSS feed ↗2 posts

Latest posts

Measuring SELECT ... FOR UPDATE Latency in PostgreSQL

At Lifen , we love digging into database performance issues. Recently, while monitoring one of our Rails applications using PgAnalyze and specific logging, we noticed something concerning: around 13–16% of a basic but frequently run query was taking more than 100ms to complete… and sometimes up to 1500ms. The culprit? SELECT ... FOR UPDATE queries that were experiencing intermittent slowdowns. The…

As Rails developers, why we are excited about PostgreSQL 17

At the time of writing this article, PostgreSQL 17 is nearly out. On September 5th, the first release candidate was published . The final release is expected on September 26th, but we can already explain why we’ve been eagerly awaiting this release since 1 year. At Lifen , we’ve loved Rails from the beginning. We have several Rails applications, each with different scopes and teams, all using…

Benoit Tigeot's blog · RSS Amplifier