Postgres Professional
   

Re: GiST index performance

From: Kevin Grittner
Subject: Re: GiST index performance
Date: ,
Msg-id: 49E71780.EE98.0025.0@wicourts.gov
(view: Whole thread, Raw)
In response to: GiST index performance  (Matthew Wakeling)
Responses: Re: GiST index performance  (Matthew Wakeling)
Re: GiST index performance  (Tom Lane)
List: pgsql-performance

Tree view

GiST index performance  (Matthew Wakeling, )
 Re: GiST index performance  ("Kevin Grittner", )
  Re: GiST index performance  (Matthew Wakeling, )
  Re: GiST index performance  (Tom Lane, )
   Re: GiST index performance  (Matthew Wakeling, )
    Re: GiST index performance  (Tom Lane, )
     Re: GiST index performance  (Matthew Wakeling, )
   Re: GiST index performance  (Matthew Wakeling, )
    Re: GiST index performance  (Matthew Wakeling, )
     Re: GiST index performance  (Tom Lane, )
 Re: GiST index performance  (Matthew Wakeling, )
 Re: GiST index performance  (dforum, )
  Re: GiST index performance  (Tom Lane, )
  Re: GiST index performance  (Craig Ringer, )
 Re: GiST index performance  (Matthew Wakeling, )
  Re: GiST index performance  (Matthew Wakeling, )
   Re: GiST index performance  (Matthew Wakeling, )
    Re: GiST index performance  (Tom Lane, )
     Re: GiST index performance  (Oleg Bartunov, )
 Re: GiST index performance  (Matthew Wakeling, )
  Re: GiST index performance  (Bruce Momjian, )
   Re: GiST index performance  (Robert Haas, )
    Re: GiST index performance  (Bruce Momjian, ) 
Matthew Wakeling <> 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: Re: GiST index performance
Next:
From: Kris Jurka
Date:
Subject: No hash join across partitioned tables?