zlacker

[parent] [thread] 1 comments
1. truth_+(OP)[view] [source] 2021-06-12 15:17:52
From the official doc link i shared already:

UNLOGGED

If specified, the table is created as an unlogged table. Data written to unlogged tables is not written to the write-ahead log (see Chapter 29), which makes them considerably faster than ordinary tables. However, they are not crash-safe: an unlogged table is automatically truncated after a crash or unclean shutdown. The contents of an unlogged table are also not replicated to standby servers. Any indexes created on an unlogged table are automatically unlogged as well.

replies(1): >>andrew+C1
2. andrew+C1[view] [source] 2021-06-12 15:34:05
>>truth_+(OP)
Uh, yeah, that confirms what osigurdson said, not that they're in-memory. For that IIRC you need to mount a ram-disk in your OS and put the table on that. Definitely also make it UNLOGGED, though.
[go to top]