The problem is way worse if you update rows, if you stick with insert and delete... | Hacker News

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

		sp1982 7 days ago \| parent \| context \| favorite \| on: Keeping a Postgres Queue Healthy The problem is way worse if you update rows, if you stick with insert and delete you can get quite far.

		help

sgarland 6 days ago [–]

In Postgres, an UPDATE is effectively an INSERT + DELETE [0].

0: https://www.cybertec-postgresql.com/en/is-update-the-same-as...

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact