Re: Disabling/Enabling index before bulk loading

From: Ravi Krishna <srkrishna(at)yahoo(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Tim Cross <theophilusx(at)gmail(dot)com>, PG mailing List <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Disabling/Enabling index before bulk loading
Date: 2018-07-10 23:53:11
Message-ID: 2793B32A-2DE6-42FC-B503-C642025D7A69@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2018-07-11 00:08:08 Re: Open Source tool to deploy/promote PostgreSQL DDL
Previous Message Gavin Flower 2018-07-10 23:28:46 Re: Open Source tool to deploy/promote PostgreSQL DDL