Re: COPY with no WAL, in certain circumstances

Поиск
Список
Период
Сортировка
От Euler Taveira de Oliveira
Тема Re: COPY with no WAL, in certain circumstances
Дата
Msg-id 20070106215305.GA3281@timbira.com
обсуждение исходный текст
Ответ на Re: COPY with no WAL, in certain circumstances  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-patches
Joshua D. Drake wrote:

> > IMHO, this deserves an GUC parameter (use_wal_in_copy?). Because a lot
> > of people use COPY because it's faster than INSERT but expects that it
> > will be in WAL. The default would be use_wal_in_copy = true.
>
> That I don't think makes sense. A copy is an all or nothing option, if a
> copy fails in the middle the whole thing is rolled back.
>
I was worried about PITR, but Simon answers my question: PITR enables so
uses WAL.

--
  Euler Taveira de Oliveira
  http://www.timbira.com/


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: COPY with no WAL, in certain circumstances
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Allow the identifier length to be increased via