Re: COPY with no WAL, in certain circumstances

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: COPY with no WAL, in certain circumstances
Дата
Msg-id 200701062140.l06LeGV29828@momjian.us
обсуждение исходный текст
Ответ на Re: COPY with no WAL, in certain circumstances  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: COPY with no WAL, in certain circumstances  (Robert Treat <xzilla@users.sourceforge.net>)
Re: COPY with no WAL, in certain circumstances  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Simon Riggs wrote:
> > > Or in other words, does this patch mean that all COPY execution that is
> > > within a transaction will ignore WAL?
> >
> > Yes, because it is possible to do in all cases.
>
> Very happy to add documentation where Tom suggested.
>
> Reason for no documentation was that CREATE INDEX and CREATE TABLE AS
> SELECT already use this optimisation, but to my knowledge neither was/is
> documented on those command pages.

I wasn't aware those used the optimization.  Seems they all should be
documented somewhere.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: "Simon Riggs"
Дата:
Сообщение: Re: COPY with no WAL, in certain circumstances
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: COPY with no WAL, in certain circumstances