> -----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
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.
In response to
pgsql-performance by date
|Next:||From: Ing. Marcos Ortiz Valmaseda||Date: 2011-01-27 20:21:16|
|Subject: Re: High load,|
|Previous:||From: DM||Date: 2011-01-27 19:26:43|
|Subject: Re: pgbench - tps for Postgresql-9.0.2 is more than tps for Postgresql-8.4.1|