Re: unlogged tables - Mailing list pgsql-performance

From Matheus de Oliveira
Subject Re: unlogged tables
Date
Msg-id CAJghg4K1WGkQ7j+FqPWaUBWzzJC-uW7gqq1Ap4=nU2peB1WPcQ@mail.gmail.com
Whole thread Raw
In response to Re: unlogged tables  (Yves Dorfsman <yves@zioup.com>)
List pgsql-performance

On Mon, Apr 13, 2015 at 5:30 PM, Yves Dorfsman <yves@zioup.com> wrote:

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.

Shutdowns in "fast" or "smart" modes does not get rid of unlogged tables. But if you do "immediate", then it does, and I don't see why people get surprised by it, as you probably shouldn't be using "immediate" mode in normal circumstances.

Best regards,
--
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br nível F!
www.dextra.com.br/postgres

pgsql-performance by date:

Previous
From: Yves Dorfsman
Date:
Subject: Re: unlogged tables
Next
From: "David G. Johnston"
Date:
Subject: Re: unlogged tables