News for hackers. Stuff that matters.
Re:It's 2026, Just Use Postgres by dry_soup on Thursday February 05, 2026 @05:33PM (#46906367)
From the article, using UNLOGGED tables puts them in memory, not on disk
Re:It's 2026, Just Use Postgres by samuelknight on Thursday February 05, 2026 @06:00PM (#46906635)
I the article is wrong. UNLOGGED means it isn't written to WAL which means recovery and rollback guarantees won't work since the transaction can finish before the page can be synchronized on disk. The table loses integrity as a trade off for a faster write.

https://www.postgresql.org/docs/current/sql-createtable.html...