6 ms·
From the article, using UNLOGGED tables puts them in memory, not on disk
by dry_soup 7mo ago
From the article, using UNLOGGED tables puts them in memory, not on disk
- samuelknight 7mo agoI 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#SQL-CREATETABLE-UNLOGGED https://www.postgresql.org/docs/current/sql-createtable.html...