Re: nested xacts and phantom Xids

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: nested xacts and phantom Xids
Дата
Msg-id 200406210017.i5L0HZL28396@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: nested xacts and phantom Xids  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: nested xacts and phantom Xids  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Let me add that outside transactions read those phantom xid only when
> > they are doing dirty reads.  What I don't understand is when do outside
> > transactions see tuples created inside a transaction?  INSERT into a
> > table with a unique key?
>
> > Once the main transaction commits, these phantom tuples should work just
> > like ordinary tuples except they get their cmin overwritten when they
> > are expired, I think.
>
> You're not doing anything to increase my confidence level in this
> concept.  You invented it, and even you aren't sure how it works.

And your point is?   I am trying to help Alvaro.  I came up with an
idea, and some thought it would help solve the problem.  What ideas do
you have to help him?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Tablespaces
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [pgsql-hackers-win32] Data directory with trailing [back]slash