Re: [GENERAL] I feel the need for speed. What am I doing

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Dann Corbit <DCorbit(at)connx(dot)com>, johnnnnnn <john(at)phaedrusdeinus(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] I feel the need for speed. What am I doing
Date: 2003-01-07 23:28:46
Message-ID: 387590000.1041982126@lerlaptop.iadfw.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-01-07 23:29:02 Re: MOVE LAST: why?
Previous Message Dann Corbit 2003-01-07 23:25:06 Re: [GENERAL] I feel the need for speed. What am I doing wrong?