> -----Original Message----- > From: Mladen Gogala [mailto:mladen.gogala@xxxxxxxxxxx] > Sent: Thursday, January 27, 2011 12:00 PM > To: Tom Lane > Cc: David Wilson; Kenneth Marshall; pgsql-performance@xxxxxxxxxxxxxx > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
