Unlogged table restart

From: Oliver Kohll <oliver(dot)lists(at)gtwm(dot)co(dot)uk>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Unlogged table restart
Date: 2011-09-12 20:56:44
Message-ID: ECA9ED53-295F-4279-88C6-1722D5A244CC@gtwm.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, great to see unlogged tables. There was discussion in the lists a while ago about various options for what would happen on server restart. I understand after a crash they'll be truncated but what about after a clean restart? Are they guaranteed to retain all committed data? If so I'll definitely use them for frequently written logs, if not I may still do so but will need some extra backup steps.

Regards
Oliver

GTwM
oliver(at)gtwm(dot)co(dot)uk
(sent from iPad)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-09-12 22:07:01 Re: Unlogged table restart
Previous Message Scott Marlowe 2011-09-12 20:51:34 Re: Index Corruption