Re: read-only UNLOGGED tables - Mailing list pgsql-general

From Leonardo Francalanci
Subject Re: read-only UNLOGGED tables
Date
Msg-id 197205.40613.qm@web29003.mail.ird.yahoo.com
Whole thread Raw
In response to Re: read-only UNLOGGED tables  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
> Yes, but  its more than fsync.
>
> You'd need to copy the whole table, all indexes and  forks to WAL if
> wal_level is set high.


"if" wal_level is set high. If it's set to minimal it would be "simple" fsyncs,
right? I mean: if it's at minimal it wouldn't take long, and it basically won't
re-write any data. This would be very useful for data that it's not "that
important", but that at the same time can be made "persistent" if needed...

Am I wrong? (I'm not too familiar with WAL...)



Leonardo




pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: read-only UNLOGGED tables
Next
From: Kalai R
Date:
Subject: Re: postgresql-9.0 service starting problem