Abnormal Growth of Index Size - Index Size 3x large than table size.

From: Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "Ashish Chugh" <ashish(dot)chugh(at)lavainternational(dot)in>
Subject: Abnormal Growth of Index Size - Index Size 3x large than table size.
Date: 2020-05-06 09:48:42
Message-ID: PS1PR0601MB36912F3E6332DE35BE11936BF0A40@PS1PR0601MB3691.apcprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Team,

We are facing a problem in our PostgreSQL production database related to abnormal growth of index size. Some of the indexes are having abnormal growth and index size is larger than table data size.
One table is having 75 G.B of index though table size is only 25 G.B. On monthly basis we are performing vacuum to release the used space.

I am attaching the screen shot for your reference. Could you please help us in resolving the same as this is degrading performance drastically.

[cid:image002(dot)png(at)01D623B9(dot)565D10F0]

Regards,
Ram Pratap.
Lava International Limited.
Tel+ 91-120-4637148
[cid:image001(dot)jpg(at)01CFD804(dot)C427DF90]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2020-05-06 10:57:44 Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
Previous Message Paul Förster 2020-05-06 09:23:50 Re: Lock Postgres account after X number of failed logins?