Re: Optimisation of INTERSECT expressions

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Optimisation of INTERSECT expressions
Дата
Msg-id 20040323170500.GA25181@wolff.to
обсуждение исходный текст
Ответ на Re: Optimisation of INTERSECT expressions  ("Phil Endecott" <spam_from_postgresql_lists@chezphil.org>)
Ответы Re: Optimisation of INTERSECT expressions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Tue, Mar 23, 2004 at 11:21:39 -0500,
  Phil Endecott <spam_from_postgresql_lists@chezphil.org> wrote:
>  Does anyone have any suggestions about how to do this?  I'd like a nice
> general technique that works for all possible subqueries, as my current
> composition with INTERSECT does.

One adjustment you might make is using INTERSECT ALL if you know there
can't be duplicates. Then time won't be wasted trying to remove duplicates.

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Benchmarking postgres on Solaris/Linux
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Optimisation of INTERSECT expressions