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

From: Ravi Krishna <srkrishna1(at)comcast(dot)net>
To: Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in>
Subject: Re: Abnormal Growth of Index Size - Index Size 3x large than table size.
Date: 2020-05-06 15:37:24
Message-ID: 0A85F167-F350-4F26-9E7A-BFAF784B0E1A@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On May 6, 2020, at 10:52 AM, Ashish Chugh <ashish(dot)chugh(at)lavainternational(dot)in> wrote:
>
> Hello Ravi,
>
>
> Total number of indexes are 10 and size is 65 GB. Shall we consider this as a normal scenario or we need to look into the growth of the indexes as this is increasing day by day and table data is not increasing so drastically. Due to this performance degradation is there and we have to run full vacuum on monthly basis.
>
> Table size is only 25 gb.
>
> Any help in this regard is appreciable.

Indexes are stored just like tables. From storage perspective there is no difference between a table and an index.
So the sum of 10 different tables to 65GB, compared to 25GB of one table sounds possible.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2020-05-06 15:48:00 Re: Lock Postgres account after X number of failed logins?
Previous Message Magnus Hagander 2020-05-06 15:28:56 Re: Lock Postgres account after X number of failed logins?