switch UNLOGGED to LOGGED

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема switch UNLOGGED to LOGGED
Дата
Msg-id 831695.27653.qm@web29019.mail.ird.yahoo.com
обсуждение исходный текст
Ответы Re: switch UNLOGGED to LOGGED  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hi,

I read the discussion at


http://archives.postgresql.org/pgsql-hackers/2011-01/msg00315.php


From what I can understand, going from/to unlogged to/from logged in
the wal_level == minimal case is not too complicated.

Suppose I try to write a patch that allows

ALTER TABLE tablename SET LOGGED (or UNLOGGED)
(proper sql wording to be discussed...)

only in the wal_level == minimal case: would it be accepted as a
"first step"? Or rejected because it doesn't allow it in the other
cases?

From what I got in the discussion, handling the other wal_level cases
can be very complicated (example: the issues in case "we *crash*
without writing an abort record").




Leonardo


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Brendan Jurd
Дата:
Сообщение: Re: [BUGS] Failed assert ((data - start) == data_size) in heaptuple.c
Следующее
От: Noah Misch
Дата:
Сообщение: Re: pg_upgrade bug found!