Re: unlogged tables

From: Richard Huxton <dev(at)archonet(dot)com>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, Anibal David Acosta <aa(at)devshock(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: unlogged tables
Date: 2011-11-14 08:58:15
Message-ID: 4EC0D827.8090601@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 14/11/11 08:10, Sergey Konoplev wrote:
> Hi,
>
> On 12 November 2011 00:18, Stephen Frost<sfrost(at)snowman(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alexandru 2011-11-14 10:00:47 What's the state of postgresql on ext4 now?
Previous Message Sergey Konoplev 2011-11-14 08:10:47 Re: unlogged tables