Re: read-only UNLOGGED tables

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: read-only UNLOGGED tables
Дата
Msg-id 197205.40613.qm@web29003.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Re: read-only UNLOGGED tables  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: read-only UNLOGGED tables
Следующее
От: Kalai R
Дата:
Сообщение: Re: postgresql-9.0 service starting problem