Re: Understanding sequential versus index scans.

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Understanding sequential versus index scans.
Дата
Msg-id dcc563d10907191805s37af2aaby39351ef0d783fb2f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Understanding sequential versus index scans.  (Robert James <srobertjames@gmail.com>)
Ответы Re: Understanding sequential versus index scans.
Список pgsql-general
On Sun, Jul 19, 2009 at 6:10 PM, Robert James<srobertjames@gmail.com> wrote:
> UNION was better, but still 5 times as slow as either query done
> individually.
> set enable_seqscan=off didn't help at all - it was totally ignored
> Is there anything else I can do?

Did you try union, or union all?

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

Предыдущее
От: Robert James
Дата:
Сообщение: Re: Understanding sequential versus index scans.
Следующее
От: Chris
Дата:
Сообщение: Re: Should I CLUSTER on PRIMARY KEY