Re: How to get RTREE performance from GIST index?

From: Clive Page <cgp(at)star(dot)le(dot)ac(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get RTREE performance from GIST index?
Date: 2009-11-22 12:08:08
Message-ID: 4B0929A8.2020702@star.le.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22/11/2009 11:52, Thom Brown wrote:
> Since this is a performance issue, this should probably have been sent
> to the pgsql-performance mailing list. But in any case, the vast
> majority of performance issues require an EXPLAIN output, or preferably
> with ANALYZE also as there is nothing to help diagnose what the query
> planner it attempting to do.

You may think it's a performance issue, but it stems from the decision
to remove from Postgres an essential facility, that of generating and
using R-trees.

I'm currently trying to generate test cases, together with EXPLAIN output.

Regards

--
Clive Page

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2009-11-22 12:09:03 Planning problem: pushing conditions through GROUP BY
Previous Message Alban Hertroys 2009-11-22 12:06:40 Re: How to get RTREE performance from GIST index?