Re: Survey on backing up unlogged tables: help us with PostgreSQL development!

On 11/18/2010 3:46 AM, Jayadevan M wrote:
> Hello,
>
>>> PostgreSQL 9.1 is likely to have, as a feature, the ability to create
>>> tables which are "unlogged", meaning that they are not added to the
>>> transaction log, and will be truncated (emptied) on database restart.
>>> Such tables are intended for highly volatile, but not very valuable,
>>> data, such as session statues, application logs, etc.
>>>
>
> One doubt - if the tables are 'unlogged' , will the DMLs against these
> still be replicated to a slave?
>
> Regards,
> Jayadevan

Yes, because the system tables, which store the layout of all tables, is
written to WAL.

-Andy