pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedDocs: GIST
3+ messages / 2 participants
[nested] [flat]
* Docs: GIST
@ 2002-12-11 18:07 Lincoln Yeoh <lyeoh@pop.jaring.my>
2002-12-12 05:41 ` Re: Docs: GIST Tom Lane <tgl@sss.pgh.pa.us>
2002-12-12 21:02 ` Re: Docs: GIST Lincoln Yeoh <lyeoh@pop.jaring.my>
0 siblings, 2 replies; 3+ messages in thread
From: Lincoln Yeoh @ 2002-12-11 18:07 UTC (permalink / raw)
To: pgsql-general@postgresql.org
I'm a bit confused.
In 7.3 is it possible to use GIST without using any of the stuff in
contrib/? If it is, how can it be done and in which cases should it be done?
The pgsql docs about indexes keep talking about GIST here and there, but I
can't seem to use them on anything. And there's no gist in the "ops" and
access method listing.
Having the docs say Postgresql provides GIST as one of the four access
methods, GIST supports multicolumn indexes, GIST etc, is just confusing if
the docs pertaining to indexes don't also say that in a default postgresql
installation you cannot create an index using GIST (if you can actually
create a GIST index "out of box", how??).
Another thing: is Eugene Selkov's 1998 message on GIST indexes in the 7.3
docs (see GIST Indexes) still valid? There's mention of Postgresql 6.3 and
postgres95 there too.
BTW, 7.3 is GREAT! Multiple col/row returns, prepare queries, schemas etc.
Also set enable_seq_scan=off can get rolled back to whatever it was before
now right? Cool, coz I have to force index use for a particular select.
Thanks to the postgresql dev team and everyone involved!
Cheerio,
Link.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Docs: GIST
2002-12-11 18:07 Docs: GIST Lincoln Yeoh <lyeoh@pop.jaring.my>
@ 2002-12-12 05:41 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2002-12-12 05:41 UTC (permalink / raw)
To: Lincoln Yeoh <lyeoh@pop.jaring.my>; +Cc: pgsql-general@postgresql.org
Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> I'm a bit confused.
> In 7.3 is it possible to use GIST without using any of the stuff in
> contrib/?
No, because there are no GIST opclasses in the standard installation.
They are only in contrib.
Yes, that's a bit silly. As GIST improves out of the "academic toy"
category into the "production tool" category, I expect we will migrate
GIST opclasses into the standard installation.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Docs: GIST
2002-12-11 18:07 Docs: GIST Lincoln Yeoh <lyeoh@pop.jaring.my>
@ 2002-12-12 21:02 ` Lincoln Yeoh <lyeoh@pop.jaring.my>
1 sibling, 0 replies; 3+ messages in thread
From: Lincoln Yeoh @ 2002-12-12 21:02 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-general@postgresql.org
I did figure it out eventually but it'll be clearer to mention that in the
docs - e.g. the only way to use GIST is to use the stuff in contrib. Coz I
had a bit of wishful thinking - thought that maybe some bits of GIST might
have at least become useable by default in 7.3 e.g. the simpler stuff (the
docs didn't quite contradict that).
Definitely not asking for it to be rushed in tho. Software is more reliable
when the developers know what they are doing, and they get to release stuff
when they think it's ready, not when others say it is.
Cheerio,
Link.
At 12:41 AM 12/12/02 -0500, Tom Lane wrote:
>Lincoln Yeoh <lyeoh@pop.jaring.my> writes:
> > I'm a bit confused.
> > In 7.3 is it possible to use GIST without using any of the stuff in
> > contrib/?
>
>No, because there are no GIST opclasses in the standard installation.
>They are only in contrib.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-12-12 21:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-11 18:07 Docs: GIST Lincoln Yeoh <lyeoh@pop.jaring.my>
2002-12-12 05:41 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-12-12 21:02 ` Lincoln Yeoh <lyeoh@pop.jaring.my>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox