On Wed, Jun 26, 2002 at 04:00:08PM -0400, Jorge Sarmiento wrote:
> the first one is an INDEX SCAN, the second one a SEQUENTIAL SCAN.
> number of rows in table has nothing to do...
Wrong. The number of rows has everything to do with it. If the number of
rows exceeds 50% of the table, a sequential scan is faster than an index
You can use enable_seq_scan=off to force it. Let us know if the index scan
is actually significantly faster.
Oh, you did use VACUUM ANALYZE right?
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
In response to
pgsql-general by date
|Next:||From: ljb||Date: 2002-06-27 01:01:38|
|Subject: Re: ordering error in query?|
|Previous:||From: d a||Date: 2002-06-26 23:26:22|
|Subject: Deadlock error when inserting single row|