Re: About Access paths

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: About Access paths
Date: 2005-03-07 07:57:01
Message-ID: 87wtsjc2ia.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:

> It's a fairly corner case feature, only for the case where you're
> looking for the existance of an index key but don't want any other
> data. I don't personally have any queries that could use such a
> construct, though maybe I'm missing the point.

You don't have any many-to-many relationships? Or any queries that use EXISTS
with indexable where clauses? Both of those are typical use cases for this
path.

In any case I think this type of scenario is more likely to be attacked via
some sort of "index organized table". But even that's not on the horizon right
now.

--
greg

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-03-07 09:26:05 Re: More concurent transaction over single connection
Previous Message Michael Fuhr 2005-03-07 04:30:57 Re: Pg 8.01 big trouble with LIMIT (bug !?)