Re: Brain dump: btree collapsing

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Brain dump: btree collapsing
Дата
Msg-id
1776.1045178035@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Brain dump: btree collapsing Tom Lane <tgl@sss.pgh.pa.us>
Re: Brain dump: btree collapsing Daniel Kalchev <daniel@digsys.bg>
Re: Brain dump: btree collapsing Tom Lane <tgl@sss.pgh.pa.us>
Re: Brain dump: btree collapsing Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Brain dump: btree collapsing Tom Lane <tgl@sss.pgh.pa.us>
Re: Brain dump: btree collapsing Justin Clift <justin@postgresql.org>
Re: Brain dump: btree collapsing Daniel Kalchev <daniel@digsys.bg>
Re: Brain dump: btree collapsing Tom Lane <tgl@sss.pgh.pa.us>
Re: Brain dump: btree collapsing Bruce Momjian <pgman@candle.pha.pa.us>
Re: Brain dump: btree collapsing Daniel Kalchev <daniel@digsys.bg>
Re: Brain dump: btree collapsing Tom Lane <tgl@sss.pgh.pa.us>
Re: Brain dump: btree collapsing Bruce Momjian <pgman@candle.pha.pa.us>
Re: Brain dump: btree collapsing Manfred Koizar <mkoi-pg@aon.at>
Re: Brain dump: btree collapsing Tom Lane <tgl@sss.pgh.pa.us>
Hannu Krosing  writes:
> But if we would allow the scans to find the same keys twice without ill
> effects (as was suggested earlier, for using btrees to index arrays),

How is returning the same data twice not an "ill effect"?

> then we could possibly 1) copy the key to the right 2) wait for all
> right-to-left scans that have fallen between old and new values to pass
> and only then 3) delete the "old left" key. 

How will you wait for scans that you know nothing of to go past?
Especially when they are going to be blocked by your own write lock
on the left page?
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Vince Vielhaber
Дата:
От: Bruce Momjian
Дата:
FAQ