Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist? - Mailing list pgsql-admin

From Keith
Subject Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?
Date
Msg-id CAHw75vtzSCpziH9-UcZqotEzeBYWZk9FmBbOaiKFgXFq=m1ukQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgsql-admin
Tree view


On Wed, Feb 3, 2016 at 7:42 AM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Stephen Tahmosh wrote:
> Is there any case where this data, in an unlogged table, would persist through a server “crash”?
> (however caused).

No.
That is the price you pay for avoiding transaction logs.

Yours,
Laurenz Albe

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

If you upgrade to 9.5, you can take advantage of the fact that you can convert an unlogged table to a logged one with an ALTER TABLE statement. I believe this does a full rewrite of the table again, but you may be able to incorporate that into your ETL process if it ends up still being quicker than doing the ETL directly on a normal table.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid memory alloc request size 18446744073709551614
Next
From: Guillaume Lelarge
Date:
Subject: Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?