:* 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
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
10 matches
Mail list logo