Re: unlogged tables

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