On Aug 15, 2007, at 2:11 PM, Gregory Stark wrote:
"Decibel!" <decibel@xxxxxxxxxxx> 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@xxxxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
