Re: Disabling/Enabling index before bulk loading

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: Disabling/Enabling index before bulk loading
Дата
Msg-id 2793B32A-2DE6-42FC-B503-C642025D7A69@yahoo.com
обсуждение исходный текст
Ответ на Re: Disabling/Enabling index before bulk loading  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
Дерево обсуждения

I am very suspicious of why you need 16 indexes. Are you sure all those indexes are actually being utilized?
Try executing the attached query, You may find find some are really not needed.

This is a DATAMART application and the indexes are to satisfy a large number of queries possible from tableau. Keep in mind
this table has 200+ cols. 
That said, it is possible that a few of them may be unnecessary.  I will run your script and check that out.

thanks for the script.

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

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: Open Source tool to deploy/promote PostgreSQL DDL
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Open Source tool to deploy/promote PostgreSQL DDL