> On May 6, 2020, at 5:48 AM, Ram Pratap Maurya > <ram.mau...@lavainternational.in> wrote: > > 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. > > <image002.png> >
How many indexes are there in the table tstock_movement? Could it be that 65GB is the sum total of index size of all indexes.
