Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 9.0 has a bias against indexes - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Postgres 9.0 has a bias against indexes
Date
Msg-id AANLkTi=GrGRte=DGwQ=Z=F5wss-kL5vERT-WT9t3-AbS@mail.gmail.com
Whole thread Raw
In response to Re: Postgres 9.0 has a bias against indexes  ("Igor Neyman" <ineyman@perceptron.com>)
List pgsql-performance
Tree view 
On Thu, Jan 27, 2011 at 2:32 PM, Igor Neyman <ineyman@perceptron.com> wrote:
>> On Oracle?  Then how can it get the values it needs without
>> having to hit the data store?
>
> It doesn't.
> It does "INDEX UNIQUE SCAN" and then "TABLE ACCESS BY INDEX ROWID".

Ahhh, ok.  I thought Oracle used covering indexes by default.

pgsql-performance by date:

Previous
From: "Igor Neyman"
Date:
Subject: Re: Postgres 9.0 has a bias against indexes
Next
From: Mladen Gogala
Date:
Subject: Re: Postgres 9.0 has a bias against indexes