[HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
I've been doing some research work using the GiST indexes, but I persistently develop a problem where the system doesn't make use of the indexes during the execution of a query. If I use the examples provided here: http://wit.mcs.anl.gov/~selkovjr/pg_extensions/ For instance, and I

Re: [HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
. -david Oleg Bartunov writes: David, could you provide more info (scheme, query, postgresql version) Regards, Oleg On Sat, 5 May 2001, David McWherter wrote: I've been doing some research work using the GiST indexes, but I persistently develop

Re: [HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
in the database right now for testing purposes. -David Tom Lane writes: David McWherter [EMAIL PROTECTED] writes: I've tried adding the parameters 'restrict = eqsel' and 'join = eqjoinsel' to the datatype operators, but that doesn't seem to change anything. You might have better luck

Re: [HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
words on it after my current workload subsides a bit. -David Tom Lane writes: David McWherter [EMAIL PROTECTED] writes: But I still get the issue that my queries don't seem to trigger the GiST indexes to be used. Perhaps the problem is that the system just thinks that the query doesn't