:* pgsql-gene...@postgresql.org; Ram Pratap Maurya
*Subject:* Re: Abnormal Growth of Index Size - Index Size 3x large than
table size.
On May 6, 2020, at 10:52 AM, Ashish Chugh
mailto:ashish.ch...@lavainternational.in>> wrote:
Hello Ravi,
Total number of indexes are 10 an
On Thu, May 7, 2020 at 8:50 AM Ashish Chugh <
ashish.ch...@lavainternational.in> wrote
> To improve performance and release index space from database, We are
> running FULL Vacuum on monthly basis.
>
> On PostgreSQL website it is not recommended to run FULL Vacuum on
> Production Database and this
Chugh
Cc: pgsql-gene...@postgresql.org; Ram Pratap Maurya
Subject: Re: Abnormal Growth of Index Size - Index Size 3x large than table
size.
On May 6, 2020, at 10:52 AM, Ashish Chugh
mailto:ashish.ch...@lavainternational.in>>
wrote:
Hello Ravi,
Total number of indexes are 10 and size
> On May 6, 2020, at 10:52 AM, Ashish Chugh
> 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
>
> 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.
20-4637148
[cid:image001.jpg@01CFD804.C427DF90]
From: Ravi Krishna [mailto:srkrish...@comcast.net]
Sent: 06 May 2020 16:28
To: Ram Pratap Maurya
Cc: pgsql-gene...@postgresql.org; Ashish Chugh
Subject: Re: Abnormal Growth of Index Size - Index Size 3x large than table
size.
On May 6, 2020, at 5:48 AM,
Indexes larger than the table may be expected if there are many. It may be
prudent to check if they are being used in pg_stat_all_indexes.
If there are just a few indexes that are becoming bloated quickly, you'd
want to ensure your autovacuum settings are tuned more aggressively, and
consider lowe
Hi
On 06.05.20 11:48, Ram Pratap Maurya wrote:
> 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 thoug
> On May 6, 2020, at 5:48 AM, Ram Pratap Maurya
> 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
