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

2020-05-07 Thread Adrian Klaver
:* 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

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

2020-05-07 Thread Michael Lewis
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

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

2020-05-07 Thread Ashish Chugh
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

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

2020-05-06 Thread Ravi Krishna
> 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

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

2020-05-06 Thread Ravi Krishna
> > 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.

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

2020-05-06 Thread Ram Pratap Maurya
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,

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

2020-05-06 Thread Michael Lewis
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

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

2020-05-06 Thread Christian Ramseyer
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

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

2020-05-06 Thread Ravi Krishna
> 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

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

2020-05-06 Thread Ram Pratap Maurya
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 w