1 min read 57 words Updated Sep 24, 2026 Created Sep 24, 2026
#Database#SQL#caching#postgresql

Unlogged tables in Postgresql are tables which are faster writing. This is because unlogged tables are not using the write-ahead-log. Yet, when crashing or restarting, contents in the unlogged table is usually lost, thus, similar to an in-memory DB. Yet, unlogged tables are still written to the disk.

Creating an unlogged table: CREATE UNLOGGED TABLE example (...);