Re: COPY with no WAL, in certain circumstances

Поиск
Список
Период
Сортировка
От Euler Taveira de Oliveira
Тема Re: COPY with no WAL, in certain circumstances
Дата
Msg-id 20070106184157.GC3022@timbira.com
обсуждение исходный текст
Ответ на COPY with no WAL, in certain circumstances  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: COPY with no WAL, in certain circumstances  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: COPY with no WAL, in certain circumstances  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Simon Riggs wrote:

> As discussed on -hackers, its possible to avoid writing any WAL at all
> for COPY in these circumstances:
>
Cool.

> The enclosed patch implements this, as discussed. There is no user
> interface to enable/disable, just as with CTAS and CREATE INDEX; no
> docs, just code comments.
>
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.


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


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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: COPY with no WAL, in certain circumstances
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: COPY with no WAL, in certain circumstances