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

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: [GENERAL] I feel the need for speed. What am I doing
Дата
Msg-id 387590000.1041982126@lerlaptop.iadfw.net
обсуждение исходный текст
Ответ на Re: [GENERAL] I feel the need for speed. What am I doing wrong?  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-hackers
Дерево обсуждения 

--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 по дате отправления:

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: [GENERAL] I feel the need for speed. What am I doing wrong?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: MOVE LAST: why?