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.paqu...@gmail.com> wrote: > On Thu, Jan 22, 2015 at 11:06 PM, Andrey Lizenko <lizenk...@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
