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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
