Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] I feel the need for speed. What am I doing - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: [GENERAL] I feel the need for speed. What am I doing
Date
Msg-id 387590000.1041982126@lerlaptop.iadfw.net
Whole thread Raw
In response to Re: [GENERAL] I feel the need for speed. What am I doing wrong?  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Tree view 

--On Tuesday, January 07, 2003 15:25:06 -0800 Dann Corbit 
<DCorbit@connx.com> 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: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: [GENERAL] I feel the need for speed. What am I doing wrong?
Next
From: Bruce Momjian
Date:
Subject: Re: MOVE LAST: why?