Re: unlogged tables - Mailing list pgsql-performance

From Richard Huxton
Subject Re: unlogged tables
Date
Msg-id 4EC0D827.8090601@archonet.com
Whole thread Raw
In response to Re: unlogged tables  (Sergey Konoplev <gray.ru@gmail.com>)
Responses Re: unlogged tables  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-performance
On 14/11/11 08:10, Sergey Konoplev wrote:
> Hi,
>
> On 12 November 2011 00:18, Stephen Frost<sfrost@snowman.net>  wrote:
>> In a crash, unlogged tables are automatically truncated.
>
> BTW I wonder what for they are truncated in a crash case?

Because they bypass the transaction-log (WAL), hence unlogged.

There's no way to know whether there were partial updates applied when
the system restarts.

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: unlogged tables
Next
From: Sergey Konoplev
Date:
Subject: Re: unlogged tables