[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: [GENERAL] read-only UNLOGGED tables
From: Leonardo Francalanci <m_lists () yahoo ! it>
Date: 2011-03-31 12:55:57
Message-ID: 197205.40613.qm () web29003 ! mail ! ird ! yahoo ! com
[Download RAW message or body]
> 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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic