Kashmira Patel wrote:
> So I would have to put in lots of rows of data in the table
> before using the explain command?
No, but PostgreSQL's query planner may take a different approach for a small
table than a large one. The statistics used are generated during VACUUM
ANALYZE/VACUUM FULL operations and, under 8.1, are probably maintained by
autovacuum, but you can always vacuum manually and see if that changes the
query plan.
-Owen
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
