--On Tuesday, January 07, 2003 15:25:06 -0800 Dann Corbit <[EMAIL PROTECTED]> wrote:
No analyze for 7.1.3. Just ran vacuum a few minutes before the query. No boost at all. Even with SET enable_seqscan = 0 it still does a table scan.
did you do VACUUM ANALYZE?
If not, the stats weren't updated. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
