Re: Index AM change proposals, redux
От
Zeugswetter Andreas OSB SD
Тема
Re: Index AM change proposals, redux
Дата
Msg-id
E1539E0ED7043848906A8FF995BDA57902F90A0E@m0143.s-mxs.net
Ответ на
Index AM change proposals, redux (Tom Lane)
Список
Дерево обсуждения
Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Teodor Sigaev <teodor@sigaev.ru>
Re: Index AM change proposals, redux Bruce Momjian <bruce@momjian.us>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Martijn van Oosterhout <kleptog@svana.org>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Gregory Stark <stark@enterprisedb.com>
Re: Index AM change proposals, redux Martijn van Oosterhout <kleptog@svana.org>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Bruce Momjian <bruce@momjian.us>
Re: Index AM change proposals, redux Simon Riggs <simon@2ndquadrant.com>
Re: Index AM change proposals, redux Decibel! <decibel@decibel.org>
Re: Index AM change proposals, redux ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Index AM change proposals, redux Bruce Momjian <bruce@momjian.us>
Re: Index AM change proposals, redux Gregory Stark <stark@enterprisedb.com>
Re: Index AM change proposals, redux Heikki Linnakangas <heikki@enterprisedb.com>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Bruce Momjian <bruce@momjian.us>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Heikki Linnakangas <heikki@enterprisedb.com>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Heikki Linnakangas <heikki@enterprisedb.com>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Teodor Sigaev <teodor@sigaev.ru>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Heikki Linnakangas <heikki@enterprisedb.com>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Teodor Sigaev <teodor@sigaev.ru>
Re: Index AM change proposals, redux Oleg Bartunov <oleg@sai.msu.su>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Oleg Bartunov <oleg@sai.msu.su>
Re: Index AM change proposals, redux Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Index AM change proposals, redux Heikki Linnakangas <heikki@enterprisedb.com>
Re: Index AM change proposals, redux Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: Index AM change proposals, redux Heikki Linnakangas <heikki@enterprisedb.com>
Re: Index AM change proposals, redux Teodor Sigaev <teodor@sigaev.ru>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Teodor Sigaev <teodor@sigaev.ru>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux Teodor Sigaev <teodor@sigaev.ru>
Re: Index AM change proposals, redux "Zeugswetter Andreas OSB SD" <Andreas.Zeugswetter@s-itsolutions.at>
Re: Index AM change proposals, redux Tom Lane <tgl@sss.pgh.pa.us>
Re: Index AM change proposals, redux "Zeugswetter Andreas OSB SD" <Andreas.Zeugswetter@s-itsolutions.at>
> * GIT (Grouped Index Tuple) indexes, which achieve index space savings > in btrees by having a single index tuple represent multiple heap tuples > (on a single heap page) containing a range of key values. I am not sure > what the development status is --- Heikki had submitted a completed > patch but there seemed to be agreement on making changes, and that's not > been done AFAIK. The really serious problem I've got with it is that > it'd foreclose the possibility of returning actual index keys from btree > indexes, thus basically killing the usefulness of that idea. I'm not > convinced it would offer enough gain to be worth paying that price. > Another issue is that we'd need to check how much of the use-case for > GIT has been taken over by HOT. I do not see the serious problem ? The one key that is stored would represent all tuples it points to. So the interface could eighter be designed to allow skipping the key in one go, or return the same key repeatedly. All that the second approach would need is return the key and the heap tuple pointer in two different vars. Andreas
В списке pgsql-hackers по дате отправления