Re: LIKE query running slow

Поиск
Список
Период
Сортировка
От Garrett Bladow
Тема Re: LIKE query running slow
Дата
Msg-id Pine.LNX.4.44.0309231940380.17479-100000@rocko.cc.ndsu.nodak.edu
обсуждение исходный текст
Ответ на Re: LIKE query running slow  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Tue, 23 Sep 2003, Josh Berkus wrote:

> Garrett,
>
> > Recently we upgraded the RAM in our server. After the install a LIKE query
> that used to take 5 seconds now takes 5 minutes. We have tried the usual
> suspects, VACUUM, ANALYZE and Re-indexing.
> >
> > Any thoughts on what might have happened?
>
> Bad RAM?   Have you tested it?

RAM was tested and is good.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] osdl-dbt3 run results - puzzled by the execution
Следующее
От: Joseph Bove
Дата:
Сообщение: Re: Performance issue