RE: Re: Strangeness in xid allocation / snapshot setup

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Re: Strangeness in xid allocation / snapshot setup
Дата
Msg-id 3705826352029646A3E91C53F7189E320166C9@sectorbase2.sectorbase.com
обсуждение исходный текст
Ответ на Strangeness in xid allocation / snapshot setup  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> >> Given this, I'm wondering why we bother with having a separate
> >> XidGenLock spinlock at all.  Why not eliminate it and use SInval
> >> spinlock to lock GetNewTransactionId and ReadNewTransactionId?
> 
> > Reading all MyProc in GetSnashot may take long time - why disallow
> > new Tx to begin.
> 
> Because we need to synchronize?  It bothers me that we're assuming
> that fetching/storing XIDs is atomic.  There's no possibility at all
> of going to 8-byte XIDs as long as the code is like this.
> 
> I doubt that a spinlock per PROC structure would be a better answer,
> either; the overhead of getting and releasing each lock would be
> nontrivial, considering the small number of instructions spent at
> each PROC in these routines.

Isn't spinlock just a few ASM instructions?... on most platforms...

Vadim


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Rule recompilation
Следующее
От: Jean-Michel POURE
Дата:
Сообщение: Re: Rule recompilation