David Garamond <lists@zara.6.isreserved.com> writes:
> 1. script to create the test table (a 1mil-record table; each record
> contains 1-40 random bytes):
This script is lacking a VACUUM or ANALYZE command, so the planner
doesn't know how large the table is. Note the ridiculously small
cost estimates in EXPLAIN ...
regards, tom lane