Re: [PERFORM] Delete, foreign key, index usage

Поиск
Список
Период
Сортировка
От Tomas Vondra
Тема Re: [PERFORM] Delete, foreign key, index usage
Дата
Msg-id 54e42679-7ec5-b097-db7b-f04c9abfc3c6@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Delete, foreign key, index usage  (Johann Spies <johann.spies@gmail.com>)
Ответы Re: [PERFORM] Delete, foreign key, index usage  (Johann Spies <johann.spies@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On 04/24/2017 08:48 AM, Johann Spies wrote:
>
> Why would the planner prefer the use the gin index and not the btree
> index in this case?
>

You'll need to show what queries are you running - that's a quite
important piece of information, and I don't see it anywhere in this
thread. Seeing explain plans would also be helpful.

regards

--
Tomas Vondra                  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Johann Spies
Дата:
Сообщение: Re: [PERFORM] Delete, foreign key, index usage
Следующее
От: Andres Freund
Дата:
Сообщение: [PERFORM] Questionaire: Common WAL write rates on busy servers.