Teodor Sigaev [EMAIL PROTECTED] wrote:
pluggable parameters for index.
I think, we may
can add to pg_opclass's definition method/parameter name and create some API
(may be, index specific) to propagate parameter's to module's interface
functions to index.
How abount adding a new option
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php
Just to follow up on the discussion of that thread: what's been
implemented is a way to store arbitrary name=value strings in an index's
pg_class entry, and to make these available in a pre-parsed form through
the index relcache
Teodor Sigaev [EMAIL PROTECTED] writes:
can add to pg_opclass's definition method/parameter name and create some API
(may be, index specific) to propagate parameter's to module's interface
functions to index.
Huh? You can get them from the index's Relation structure. I don't
think there's
Just wanted to make clear to Hackers that the gates are now open to
include other parameters for CREATE INDEX, as originally requested here:
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php
The new WITH (param=value...) syntax could easily be extended to include
a variety of
Simon Riggs [EMAIL PROTECTED] writes:
Just wanted to make clear to Hackers that the gates are now open to
include other parameters for CREATE INDEX, as originally requested here:
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00851.php
Just to follow up on the discussion of that
Added to TODO:
* Allow CREATE INDEX to take an additional parameter for use with
special index types
---
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
On Wed, Sep 21, 2005 at 08:47:04AM
On Wed, Sep 21, 2005 at 08:47:04AM +0300, Hannu Krosing wrote:
On K, 2005-09-21 at 09:01 +0400, Oleg Bartunov wrote:
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.
If not
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,
Oleg Bartunov wrote:
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 ?
According to the docs:
CREATE INDEX is a PostgreSQL language extension. There are no
provisions for
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
Martijn van Oosterhout kleptog@svana.org writes:
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?
I should think that the index ought to remember any
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
On K, 2005-09-21 at 09:01 +0400, Oleg Bartunov wrote:
On Tue, 20 Sep 2005, Martijn van Oosterhout wrote:
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
13 matches
Mail list logo