[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 pla

Re: [HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
x, compress,decompress,picksplit,union are called as expected. During the execution of the query, however, nothing happens. I've found the same exact results using the 'pggist' examples (a suite including intproc,boxproc,polyproc,textproc), and the examples found here: http://

Re: [HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
've only got about a dozen elements 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 t

Re: [HACKERS] GiST indexing problems...

2001-05-05 Thread David McWherter
a few 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