Postgres Pro
Downloads
Home   >   mailing lists

Re: Survey on backing up unlogged tables: help us with PostgreSQL development! - Mailing list pgsql-general

From Tom Lane
Subject Re: Survey on backing up unlogged tables: help us with PostgreSQL development!
Date
Msg-id 27618.1290010028@sss.pgh.pa.us
Whole thread Raw
In response to Re: Survey on backing up unlogged tables: help us with PostgreSQL development!  (Derrick Rice <derrick.rice@gmail.com>)
List pgsql-general
Tree view 
Derrick Rice <derrick.rice@gmail.com> writes:
> Is there a difference between a global temporary table (if such a thing
> existed in PostgreSQL) and an unlogged table?

Yes --- IIRC, a "global temp table" per spec has session-local contents.
An unlogged table acts just like any other table except with respect to
crash safety.

            regards, tom lane

pgsql-general by date:

Previous
From: rmd22
Date:
Subject: Re: Storing old and new tuple values after an UPDATE, INSERT or DELETE
Next
From: Steve Crawford
Date:
Subject: Re: Survey on backing up unlogged tables: help us with PostgreSQL development!