PostgreSQL Unlogged Tables - Look Ma, No WAL! | Crunchy Data Blog

While supporting customers at Crunchy Data, I sometimes see users add unlogged tables. In this post, I'm going to review some of the specifics about this. Unlogged tables in Postgresql are a way of preventing specific tables from generating WAL (Write Ahead Log) information by adding the unlogged keyword to a create table command: CREATE UNLOGGED TABLE foobar (id int); You can also change existing

[tgk]

unlogged tableはレプリカからは読めない。PostgreSQLのレプリケーションがWALをレプリカに転送することで実現されているから