Re: unlogged tables

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "'Richard Huxton'" <dev(at)archonet(dot)com>, "Anibal David Acosta" <aa(at)devshock(dot)com>, "'Sergey Konoplev'" <gray(dot)ru(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>, "'Stephen Frost'" <sfrost(at)snowman(dot)net>
Subject: Re: unlogged tables
Date: 2011-11-14 17:26:32
Message-ID: 4EC0FAE80200002500042E6C@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Anibal David Acosta" <aa(at)devshock(dot)com> wrote:

> Maybe an option like "Recover from file " will be useful
> So, for example, daily some process do a COPY of entire table to a
> file
>
> In case of crash postgres recover content from the file.

If you need to recover file contents on a crash, then an unlogged
table is probably not the right choice. There is always
asynchronous commit.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Anibal David Acosta 2011-11-14 17:38:31 Re: unlogged tables
Previous Message Anibal David Acosta 2011-11-14 17:05:51 Re: unlogged tables