Re: unlogged tables - Mailing list pgsql-performance

From Sergey Konoplev
Subject Re: unlogged tables
Date
Msg-id CAL_0b1tuxi9YVhGKsNUSTZCUBXgOmppan7w+KkRZARbQ=u4P5w@mail.gmail.com
Whole thread Raw
In response to Re: unlogged tables  (Richard Huxton <dev@archonet.com>)
Responses Re: unlogged tables
List pgsql-performance
On 14 November 2011 12:58, Richard Huxton <dev@archonet.com> wrote:
> 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.

I probably did not understand the "truncate" meaning correct. It
truncates all the records of the table or several recent records only?

>
> --
>  Richard Huxton
>  Archonet Ltd
>



--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray.ru@gmail.com Skype: gray-hemp

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: unlogged tables
Next
From: Richard Huxton
Date:
Subject: Re: unlogged tables