Hacker News new | ask | show | jobs
by dry_soup 126 days ago
From the article, using UNLOGGED tables puts them in memory, not on disk
1 comments

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...