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@xxxxxxxxx> wrote:
On Thu, Jan 22, 2015 at 11:06 PM, Andrey Lizenko <lizenko79@xxxxxxxxx> 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
