Postgres Pro
Downloads
Home   >   mailing lists

Abnormal Growth of Index Size - Index Size 3x large than table size. - Mailing list pgsql-general

From Ram Pratap Maurya
Subject Abnormal Growth of Index Size - Index Size 3x large than table size.
Date
Msg-id PS1PR0601MB36912F3E6332DE35BE11936BF0A40@PS1PR0601MB3691.apcprd06.prod.outlook.com
Whole thread Raw
Responses Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize.  (Ravi Krishna <srkrishna1@comcast.net>)
Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize.  (Christian Ramseyer <rc@networkz.ch>)
List pgsql-general
Tree view

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.

 

 

 

Regards,

Ram Pratap.

Lava International Limited.

Tel+  91-120-4637148

cid:image001.jpg@01CFD804.C427DF90

 

 

Attachment

pgsql-general by date:

Previous
From: Paul Förster
Date:
Subject: Re: Lock Postgres account after X number of failed logins?
Next
From: Ravi Krishna
Date:
Subject: Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize.