Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?

Поиск
Список
Период
Сортировка
От Keith
Тема Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?
Дата
Msg-id CAHw75vtzSCpziH9-UcZqotEzeBYWZk9FmBbOaiKFgXFq=m1ukQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Ответы Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: invalid memory alloc request size 18446744073709551614
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: Re: Postgres 9.4 unlogged table. Under any circumstance after server crash would data persist?