Re: unlogged tables - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: unlogged tables
Date
Msg-id 4EC0FAE80200002500042E6C@gw.wicourts.gov
Whole thread Raw
In response to Re: unlogged tables  ("Anibal David Acosta" <aa@devshock.com>)
Responses Re: unlogged tables  ("Anibal David Acosta" <aa@devshock.com>)
List pgsql-performance
"Anibal David Acosta" <aa@devshock.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

pgsql-performance by date:

Previous
From: "Anibal David Acosta"
Date:
Subject: Re: unlogged tables
Next
From: "Anibal David Acosta"
Date:
Subject: Re: unlogged tables