Re: user-defined tree methods in GIST

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: user-defined tree methods in GIST
Дата
Msg-id 20070306113640.GA9124@svana.org
обсуждение исходный текст
Ответ на user-defined tree methods in GIST  ("sharath kumar" <k.sharat@gmail.com>)
Список pgsql-hackers
On Tue, Mar 06, 2007 at 01:50:34PM +0530, sharath kumar wrote:
> I need some help in building new index structure using GIST.
> I have to include a procedure for restructuring the tree immediately after
> i have created the index using gist. How do i do it?
> Actually I am trying to implement the slim-tree index using gist. To
> increase the performance, a slim-down algorithm runs after creation of the
> slim-tree. Where can i give a call to this slim-down procedure after the
> tree has been built using gist?

I don't quite understand what a slim-tree index is, but by my reading
it's an algorithm to make picksplit work better. I don't think you need
to touch the index machinery at all.

Also, I don't think it's a good plan to try and manipulate the index
wholesale after it's built. Once it's built, queries are going want to
use it and any changes are are going to need to be WAL logged and made
crash safe which seems quite a lot of work for something you can
probably do during picksplit.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Aggressive freezing in lazy-vacuum
Следующее
От: NikhilS
Дата:
Сообщение: Auto creation of Partitions