--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

Reply via email to