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
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 |