WIP: SP-GiST, Space-Partitioned GiST
От
Oleg Bartunov
Тема
WIP: SP-GiST, Space-Partitioned GiST
Дата
Msg-id
Pine.LNX.4.64.1108312241050.26195@sn.sai.msu.ru
Список
Дерево обсуждения
WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Andreas Joseph Krogh <andreak@officenet.no>
Re: WIP: SP-GiST, Space-Partitioned GiST Alexander Korotkov <aekorotkov@gmail.com>
Re: WIP: SP-GiST, Space-Partitioned GiST Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Teodor Sigaev <teodor@sigaev.ru>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Teodor Sigaev <teodor@sigaev.ru>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Greg Smith <greg@2ndQuadrant.com>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP: SP-GiST, Space-Partitioned GiST Alexander Korotkov <aekorotkov@gmail.com>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Re: WIP: SP-GiST, Space-Partitioned GiST Oleg Bartunov <oleg@sai.msu.su>
Hi there, attached is our WIP-patch for 9.2 development source tree, which provides implementation of SP-GiST (prototype was presented at PGCon-2011, see http://www.pgcon.org/2011/schedule/events/309.en.html and presentation for details) as a core feature. Main differences from prototype version: 1. Now it's part of pg core, not contrib module 2. It provides more operations for quadtree and suffix tree 3. It uses clustering algorithm of nodes on disk and has much better utilization of disk space. Fillfactor is supported 4. Some corner cases were eliminated 5. It provides support for concurency and recovery (inserts are logged, supports for deletes, and log replay will be added really soon) So, now code contains almost all possible overhead of production code and we ask hackers to test performance on real data sets. We expect the same performance for random data (since almost no overlaps) and much better performance on real-life data, plus much better index creation time. Also, we appreciate your comments and suggestions about API. Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
В списке pgsql-hackers по дате отправления