Re: Have I b0rked something? Slow comparisons on "where x in (...)"

Поиск
Список
Период
Сортировка
От Stephen Harris
Тема Re: Have I b0rked something? Slow comparisons on "where x in (...)"
Дата
Msg-id 20070502195117.GA22941@pugwash.spuddy.org
обсуждение исходный текст
Ответ на Re: Have I b0rked something? Slow comparisons on "where x in (...)"  ("Dann Corbit" <DCorbit@connx.com>)
Ответы Re: Have I b0rked something? Slow comparisons on "where x in (...)"  (Richard Huxton <dev@archonet.com>)
Список pgsql-general
Дерево обсуждения 
On Wed, May 02, 2007 at 12:45:08PM -0700, Dann Corbit wrote:
> Have you done a vacuum on the table recently?

We vacuum daily and cluster weekly after the nightly activities have been
performed.

> IN list, then the IN list might benefit from a bit of analysis for

The IN list is just a set of integers (it's an integer index) generated
from some selects on other tables earlier in our processing.  I don't
have any choice as to what is in the IN list :-)

--

rgds
Stephen

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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Have I b0rked something? Slow comparisons on "where x in (...)"
Следующее
От: "Dan Weber"
Дата:
Сообщение: forcing use of a specific (expression) index?