Thread: BUG #16002: Index size larger than the base table size and growing abnormally.

BUG #16002: Index size larger than the base table size and growing abnormally.

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      16002
Logged by:          ram pratap maurya
Email address:      ram.maurya@lavainternational.in
PostgreSQL version: 11.0
Operating system:   RHEL 7
Description:

Hi Team,

We are facing problem with our database growth though growth of the tables
is not at all concenred but index sizes are getting increased abnormally and
couple of tables are having 3 times larger indexes. 

Could you please let us know what can be the root cause of this problem.
Platform details are as follows.

OS - RHEL 7
Postgres Database - 11.0
Index Type Used - B-Tree

Please le us know if further information is required from our end to resolve
this problem.

Regards,
Ram Pratap