Re: Postgres 9.0 has a bias against indexes

> -----Original Message-----
> From: Mladen Gogala [mailto:mladen(dot)gogala(at)vmsinfo(dot)com]
> Sent: Thursday, January 27, 2011 12:00 PM
> To: Tom Lane
> Cc: David Wilson; Kenneth Marshall; pgsql-performance(at)postgresql(dot)org
> Subject: Re: Postgres 9.0 has a bias against indexes
>
> On 1/27/2011 11:40 AM, Tom Lane wrote:
> > It is worth noting that EXPLAIN results should not be extrapolated
> > to situations other than the one you are actually testing; for
> > example, results on a toy-sized table cannot be
> assumed to apply to
> > large tables.
> Well, that's precisely what I tried. Bummer, I will have to
> copy a large table over.
>
> --
> Mladen Gogala
> Sr. Oracle DBA
> 1500 Broadway
> New York, NY 10036
> (212) 329-5251
> www.vmsinfo.com
>
>

Mladen,

I don't think, this is exclusive Postgres feature.
I'm pretty sure, Oracle optimizer will do "TABLE ACCESS (FULL)" instead
of using index on 14-row table either.

Regards,
Igor Neyman