Re: Delete, foreign key, index usage

Поиск
Список
Период
Сортировка
От Johann Spies
Тема Re: Delete, foreign key, index usage
Дата
Msg-id CAGZ55DRr=wVHJgfrBb9eGVWyL81ObJw=7kpfxpfYyeS4osTKmw@mail.gmail.com
обсуждение исходный текст
Ответ на Delete, foreign key, index usage  (Johann Spies <johann.spies@gmail.com>)
Ответы Re: Delete, foreign key, index usage  (Rick Otten <rottenwindfish@gmail.com>)
Список pgsql-performance
On 4 April 2017 at 14:07, Johann Spies <johann.spies@gmail.com> wrote:

> Why would that be?

To answer my own question.  After experimenting a lot we found that
9.6 uses a parallel seqscan that is actually a lot faster than using
the index on these large tables.

This, to us was a surprise!

Regards
Johann

--
Because experiencing your loyal love is better than life itself,
my lips will praise you.  (Psalm 63:3)


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

Предыдущее
От: Johann Spies
Дата:
Сообщение: Delete, foreign key, index usage
Следующее
От: Rick Otten
Дата:
Сообщение: Re: Delete, foreign key, index usage