Re: SELECT speed with LIKE

Поиск
Список
Период
Сортировка
От Ross J. Reedstrom
Тема Re: SELECT speed with LIKE
Дата
Msg-id 20000404095634.C22876@rice.edu
обсуждение исходный текст
Ответ на Re: SELECT speed with LIKE  (Jim Richards <grumpy@cyber4.org>)
Список pgsql-general
On Tue, Apr 04, 2000 at 06:30:17PM +1000, Jim Richards wrote:
<nothing, because it was in html>

Boy, _that_ was hard to read. Not only HTML, but lots of   all
over. I _think_ Jim was concerned that selects on his big tables
where not using his indices. The canonical reply question is:

Have you run 'vacuum analyze' recently?

Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St.,  Houston, TX 77005

В списке pgsql-general по дате отправления:

Предыдущее
От: "Sampath, Krishna"
Дата:
Сообщение: nextval(), and serial updates
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: Fetching record of the day