Re: Brain dump: btree collapsing
От
Tom Lane
Тема
Re: Brain dump: btree collapsing
Дата
Msg-id
1776.1045178035@sss.pgh.pa.us
Ответ на
Re: Brain dump: btree collapsing (Hannu Krosing)
Список
Дерево обсуждения
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 по дате отправления