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

From: Ravi Krishna <srkrishna1(at)comcast(dot)net>
To: Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in>
Subject: Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
Date: 2020-05-06 14:37:51
Message-ID: 47D4D5C5-AEFD-4C9B-8055-6B67F06CA085@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2020-05-06 15:26:10 Re: Lock Postgres account after X number of failed logins?
Previous Message Adrian Klaver 2020-05-06 14:27:55 Re: pg_basebackup inconsistent performance