Re: GiST index performance - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: GiST index performance
Date
Msg-id 49E71780.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to GiST index performance  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: GiST index performance  (Matthew Wakeling <matthew@flymine.org>)
Re: GiST index performance  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Matthew Wakeling <matthew@flymine.org> wrote:
> I have been doing some queries that are best answered with GiST
> indexes

For what definition of "best answered"?

Since an index is only a performance tuning feature (unless declared
UNIQUE), and should never alter the results (beyond possibly affecting
row order if that is unspecified), how is an index which performs
worse than an alternative the best answer?

-Kevin

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: GiST index performance
Next
From: Matthew Wakeling
Date:
Subject: Re: GiST index performance