Re: unlogged tables - Mailing list pgsql-performance

From Yves Dorfsman
Subject Re: unlogged tables
Date
Msg-id 552C2779.8050004@zioup.com
Whole thread Raw
In response to Re: unlogged tables  (dgabriel <gabriel.dodan@gmail.com>)
Responses Re: unlogged tables  (Matheus de Oliveira <matioli.matheus@gmail.com>)
List pgsql-performance
On 2015-04-13 14:16, dgabriel wrote:
> That will be a very useful feature.

I agree, unlogged tables would be a lot more useful if they didn't "disappear"
on re-start.


> could be expensive. Also i have to detect when postgres crush, i have no
> idea how i can detect if postgres crushed. Then i have somehow to attache a
> script at postgres start, to restore the dumps...the dump solution is very
> complicate and  unreliable. A periodic flush feature will be amazing!

In my experience postgres is very aggressive in getting rid of unlogged
tables, it does get rid of them from shutdowns that seem perfectly fine (no
crash). A lot of people get surprised by this.

--
http://yves.zioup.com
gpg: 4096R/32B0F416



pgsql-performance by date:

Previous
From: dgabriel
Date:
Subject: Re: unlogged tables
Next
From: Matheus de Oliveira
Date:
Subject: Re: unlogged tables