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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
