# Old tech is sometimes better - a case study based on blogpost from Now-Next...

DevFeed: [Old tech is sometimes better - a case study based on blogpost from Now-Next...](<https://devfeed.tech/articles/old-tech-is-sometimes-better-a-case-study-based-on-blogpost-from-now-next-88510.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/10/16/old-tech-is-sometimes-better-a-case-study-based-on-blogpost-from-now-next/>)

Author: depesz

Published: 2026-10-16T10:09:03Z

Content type: article

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [table-partitioning](<https://devfeed.tech/topics/table-partitioning.md>)

Tags: [audit](<https://devfeed.tech/tags/audit.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [changes](<https://devfeed.tech/tags/changes.md>), [hstore](<https://devfeed.tech/tags/hstore.md>), [jsonb](<https://devfeed.tech/tags/jsonb.md>), [logging](<https://devfeed.tech/tags/logging.md>), [now-next](<https://devfeed.tech/tags/now-next.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [reaction](<https://devfeed.tech/tags/reaction.md>), [trigger](<https://devfeed.tech/tags/trigger.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

## AI overview

The author benchmarks PostgreSQL trigger-based change logging using JSONB and hstore, comparing full-row logging with logging only changed columns. In the reported tests, hstore is faster and uses somewhat less disk space, with diff logging faster than full-row logging. The author cautions that hstore is not necessarily better for every use case.

## Source excerpt

Some time ago I read this blogpost. They wrote about logging changes to table using a trigger, but one thing that caught my attention was: Storing only the changed columns made the log five times smaller and the trigger slower. Figured I can try it myself... Unfortunately they didn't provide schema of table, nor test ... Continue reading "Old tech is sometimes better - a case study based on blogpost from Now-Next..."