Re: pgsql: Support unlogged tables. - Mailing list pgsql-committers

From Robert Haas
Subject Re: pgsql: Support unlogged tables.
Date
Msg-id AANLkTinmWADVT-w+TYWBVqJrTCqKeOcEVhS=wPeO2mMb@mail.gmail.com
Whole thread Raw
In response to pgsql: Support unlogged tables.  (Robert Haas <rhaas@postgresql.org>)
List pgsql-committers
On Wed, Dec 29, 2010 at 6:49 AM, Robert Haas <rhaas@postgresql.org> wrote:
> The contents of an unlogged table are WAL-logged; thus, they are not
> available on standby servers and are truncated whenever the database
> system enters recovery.  Indexes on unlogged tables are also unlogged.
> Unlogged GiST indexes are not currently supported.

Sigh.  s/are/aren't/, as Devrim just pointed out to me off-list.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-committers by date:

Previous
From: Robert Haas
Date:
Subject: pgsql: Bump XLOG_PAGE_MAGIC.
Next
From: Magnus Hagander
Date:
Subject: Re: pgsql: Add REPLICATION privilege for ROLEs