passing parameters to CREATE INDEX

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема passing parameters to CREATE INDEX
Дата
Msg-id Pine.GSO.4.63.0509202320210.20320@ra.sai.msu.su
обсуждение исходный текст
Ответы Re: passing parameters to CREATE INDEX  (Andrew Dunstan <andrew@dunslane.net>)
Re: passing parameters to CREATE INDEX  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers
Hi there,

it's desirable to be able to pass parameters to CREATE INDEX for
GiST indices. Does SQL standard has something about that so we could
implement it for 8.2 ?

Example from real life project - performance of tsearch2 could be
greatly improved if decrease signature size in gistidx.h, which is
currently hardcoded and one should compile and install tsearch2 into
differnet location and use it for specific database. It's impossible
to have different signature length for different fts indices because
we have no possibility to pass parameters to CREATE INDEX command.

    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: New dot releases
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: DISTINCT vs. GROUP BY