Re: passing parameters to CREATE INDEX

On Tue, 20 Sep 2005, Martijn van Oosterhout wrote:

> On Tue, Sep 20, 2005 at 11:26:26PM +0400, Oleg Bartunov wrote:
>> 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 ?
>
> As has been pointed out, INDEXes arn't in the SQL spec at all, so you
> can do just about anything.
>
>> 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.
>
> What syntax were you envisioning? Does this value just need to be
> passed to GiST at the creation of the the index, or does it actually
> need to remembered by the backend and passed each call? At the moment
> there is some discussion on changes to the index interface so now is
> the time to ask for what you want...

it'd be nice if parameters could be passed at the creation time only and
somehow stored, so other functions could retrieve them. It's not
convenient but also safe.

>
>

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