Hmm, imho, triggers do scale, they are just slow. But as you add more connection... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		nine_k 85 days ago \| parent \| context \| favorite \| on: Postgres LISTEN/NOTIFY does not scale Hmm, imho, triggers do scale, they are just slow. But as you add more connections, partitionss, and CPUs, the slowness per operation remains constant.

ants_a 85 days ago [–]

Triggers are not even particularly slow. They just hide the extra work that is being done and thus sometimes come back to bite programmers by adding a ton of work to statements that look like they should be quick.

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact