Postgres Pro
Downloads
Home   >   mailing lists

Re: temporary tables are logged somehow? - Mailing list pgsql-general

From Andrey Lizenko
Subject Re: temporary tables are logged somehow?
Date
Msg-id CADKuZZAcOpGjt8ZGqNEL0_LbXToPEKWrt_hUWUPzbZhHoPoaKA@mail.gmail.com
Whole thread Raw
In response to Re: temporary tables are logged somehow?  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view
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.paquier@gmail.com> wrote:
On Thu, Jan 22, 2015 at 11:06 PM, Andrey Lizenko <lizenko79@gmail.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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How to create a specific table
Next
From: Michael Paquier
Date:
Subject: Re: How to create a specific table