Re: Will modifications to unlogged tables also be flused to disk?

From: frank <halldu0815(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Will modifications to unlogged tables also be flused to disk?
Date: 2014-12-08 12:43:40
Message-ID: 1418042620032-5829600.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Janes wrote
> That's not really true. There are no per-row WAL records. There is still
> a per-transaction WAL record, the commit record. If you only care about
> the
> timing of the WAL and not the volume, changing to unlogged will not make a
> difference. (These commit-only records are automatically dealt with
> asynchronously, even if synchronous-commit is on.)
>
> Cheers,
>
> Jeff

Hi,

just to understand this answer:

Is it *NOT* possible to create an unlogged table where inserts or updates
will *NOT* modify the WAL files?

Regards, hall

--
View this message in context: http://postgresql.nabble.com/Will-modifications-to-unlogged-tables-also-be-flused-to-disk-tp5792158p5829600.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent de Phily 2014-12-08 12:54:40 Speeding up an in-progress wraparound-preventing vacuum
Previous Message bln prasad 2014-12-08 11:26:00 Updating single/multiple fields of JSON document