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