Re: unlogged tables

[Matheus de Oliveira <matioli.matheus@xxxxxxxxx>]

On Mon, Apr 13, 2015 at 5:30 PM, Yves Dorfsman <yves@xxxxxxxxx> 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