Re: temporary tables are logged somehow?

From: Andrey Lizenko <lizenko79(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: temporary tables are logged somehow?
Date: 2015-01-22 15:01:17
Message-ID: CADKuZZAcOpGjt8ZGqNEL0_LbXToPEKWrt_hUWUPzbZhHoPoaKA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Why unlogged tables behaviour is not the same?
If I try this:

> create unlogged table if not exists positiontemporarytable
> (pos_instrument_id integer, pos_code varchar(40));
> prepare pos_delete as delete from "positiontemporarytable";
> execute pos_delete;

no WAL files created at all.

On 22 January 2015 at 17:36, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
wrote:

> On Thu, Jan 22, 2015 at 11:06 PM, Andrey Lizenko <lizenko79(at)gmail(dot)com>
> wrote:
> >> 3. They are not WAL-logged.
> > Whats wrong with it in my case?
> Nothing. Temporary tables are not WAL-logged, but transaction commit is.
> --
> Michael
>

--
Regards, Andrey Lizenko

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2015-01-22 15:03:34 Re: How to create a specific table
Previous Message Adrian Klaver 2015-01-22 15:00:49 Re: How to create a specific table