On Aug 15, 2007, at 2:11 PM, Gregory Stark wrote:
> "Decibel!" <decibel@decibel.org> writes:
>> On Wed, Aug 15, 2007 at 01:26:02PM -0400, Steve Madsen wrote:
>>> On Aug 15, 2007, at 11:52 AM, Decibel! wrote:
>>>> I can't really think of a case where a seqscan wouldn't return
>>>> all the
>>>> rows in the table... that's what it's meant to do.
>
> LIMIT
Ok, you got me. :P But normally you wouldn't do a LIMIT without some
kind of an ORDER BY, which would mean scanning the whole table.
In any case, it's not a perfect metric, but in general use it seems
to be "good enough".
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)