Postgres Pro
Downloads
Home   >   mailing lists

Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize. - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Abnormal Growth of Index Size - Index Size 3x large than tablesize.
Date
Msg-id 47D4D5C5-AEFD-4C9B-8055-6B67F06CA085@comcast.net
Whole thread Raw
In response to RE: Abnormal Growth of Index Size - Index Size 3x large than table size.  (Ram Pratap Maurya <ram.maurya@lavainternational.in>)
List pgsql-general
Tree view

Hello Ravi,
 
Total number of index is 10 and 65GB is the sum total of index size of all indexes for table “tstock_movement”
I am attaching the screen shot for your reference.

 
In that case 65GB is not surprising.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_basebackup inconsistent performance
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Lock Postgres account after X number of failed logins?