logoalt Hacker News

dry_soupyesterday at 10:33 PM1 replyview on HN

From the article, using UNLOGGED tables puts them in memory, not on disk


Replies

samuelknightyesterday at 11:00 PM

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