Postgres Pro
Downloads
Home   >   mailing lists

Re: Disabling/Enabling index before bulk loading - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Disabling/Enabling index before bulk loading
Date
Msg-id 2793B32A-2DE6-42FC-B503-C642025D7A69@yahoo.com
Whole thread Raw
In response to Re: Disabling/Enabling index before bulk loading  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL
Next
From: Rob Sargent
Date:
Subject: Re: Open Source tool to deploy/promote PostgreSQL DDL