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 по дате отправления
От: Ross J. Reedstrom
Дата:
От: Merlin Moncure
Дата:
Сообщение: Re: "stored procedures"
FAQ