| 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 10:57:44 |
| Message-ID: | C2036EB3-1B4B-4C56-9D68-9803FC3E4A04@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On May 6, 2020, at 5:48 AM, Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2020-05-06 11:48:43 | Re: Lock Postgres account after X number of failed logins? |
| Previous Message | Ram Pratap Maurya | 2020-05-06 09:48:42 | Abnormal Growth of Index Size - Index Size 3x large than table size. |