Re: Question about explain of index scan

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: Question about explain of index scan
Дата
Msg-id 1125863057.5610.39.camel@fuji.krosing.net
обсуждение исходный текст
Ответ на Re: Question about explain of index scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Question about explain of index scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On R, 2005-09-02 at 11:03 -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> > I wonder why we don't support more operators on Xid, so these things are
> > avoided?  Right now we only have =, AFAIR.
> 
> I once started to make a btree opclass for XID, and stopped when it
> occurred to me that XID comparison doesn't obey the transitive law.
> btree won't like that...

Does this mean that Slony's usage of btree index on XID gives
(occasionally) wrong results ?

-- 
Hannu Krosing <hannu@skype.net>



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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Locale implementation questions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proof of concept COLLATE support with patch