Re: TRUNCATE SERIALIZABLE and frozen COPY

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: TRUNCATE SERIALIZABLE and frozen COPY
Дата
Msg-id CA+U5nML0QrMQp_HC1wAAunyO4mxYwErXC4q6QRAv_CYgQEN6KQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: TRUNCATE SERIALIZABLE and frozen COPY  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 12 November 2012 16:22, Robert Haas <robertmhaas@gmail.com> wrote:

> But I guess that raises the question - should COPY (FREEZE) silently
> ignore the option for not-new relfilenodes, or should it error out?
> Simon proposed the former, but I'm wondering if the latter would be
> better.

It's got some complex pre-conditions, so having scripts fail because
you mis-specified FREEZE would be annoying.

The option indicates "I accept the potential MVCC violation", not "it
will always freeze".

If there is a better name...

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Proof of concept: standalone backend with full FE/BE protocol
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Inadequate thought about buffer locking during hot standby replay