Re: COPY with no WAL, in certain circumstances

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: COPY with no WAL, in certain circumstances
Дата
Msg-id 1168170389.3951.76.camel@silverbirch.site
обсуждение исходный текст
Ответ на Re: COPY with no WAL, in certain circumstances  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] COPY with no WAL, in certain circumstances  (Martijn van Oosterhout <kleptog@svana.org>)
Re: [HACKERS] COPY with no WAL, in certain circumstances  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
On Sun, 2007-01-07 at 03:53 -0500, Tom Lane wrote:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
> > On Sat, 2007-01-06 at 21:18 -0500, Tom Lane wrote:
> >> Uh ... what in the world has an active portal got to do with it?
> >> I think you've confused snapshot considerations with crash recovery.
>
> > The patch sets HEAP_XMIN_COMMITTED on all of the rows loaded by COPY as
> > well.
>
> I think you just talked yourself out of getting this patch applied.

Maybe; what would be your explanation? Do you have a failure case you
know of? Perhaps if one exists, there is another route.

--
  Simon Riggs
  EnterpriseDB   http://www.enterprisedb.com



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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [HACKERS] SGML index build fix
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [HACKERS] COPY with no WAL, in certain circumstances