On Wed, 26 Jun 2002, 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...
Sure it does. As the number of rows selected approaches the number
of rows in the table the cost of the index scan relative to sequential
scan can increase due to the fact that we're reading both the index
and the heap blocks (for row validity testing - and doing it in a
possibly random order) as opposed to a sequential read set of the heap.
In response to
pgsql-general by date
|Next:||From: Andrew Sullivan||Date: 2002-06-26 21:44:14|
|Subject: Re: Advocacy Idea.|
|Previous:||From: Carl Meyer||Date: 2002-06-26 20:52:46|
|Subject: Re: unlimited undo/journaling|