Re: Performance of full outer join in 8.3

Поиск
Список
Период
Сортировка
От Grzegorz Jaśkiewicz
Тема Re: Performance of full outer join in 8.3
Дата
Msg-id 2f4958ff0904150531h32358fex5cb705472abd271e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance of full outer join in 8.3  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Performance of full outer join in 8.3  (Christian Schröder <cs@deriva.de>)
Список pgsql-general
On Wed, Apr 15, 2009 at 1:25 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> The cost of the query seems accurate, so the absence of
> attachment_isins_attachment_idx on the 8.3 plan looks to be the reason.
> There's no way it would choose to scan 8115133 rows on the pkey if the
> other index was available and usable.

hance my question, if there's index on it in 8.3 version of db.



--
GJ

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Performance of full outer join in 8.3
Следующее
От: William Temperley
Дата:
Сообщение: Re: Disconnected editing - versioning of databases