BUG #15992: Index size larger than the base table size. Sometime 3 times large

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: ram(dot)maurya(at)lavainternational(dot)in
Subject: BUG #15992: Index size larger than the base table size. Sometime 3 times large
Date: 2019-09-05 11:17:22
Message-ID: 15992-4e76de596b6855be@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 15992
Logged by: Ram Pratap Maurya
Email address: ram(dot)maurya(at)lavainternational(dot)in
PostgreSQL version: 11.0
Operating system: RHEL 7
Description:

Dear Team,

In Production system ,Index size larger than the base table size. Sometime 3
to 4 times larger.
Please suggest what can i do to stop index size.
whaen i run full vacuum , index size is decrease but again increase after a
week.

psql version 8.4, server version 11.0.

Regards,
Ram Pratap

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2019-09-05 12:16:11 Re: BUG #15977: Inconsistent behavior in chained transactions
Previous Message Thomas Munro 2019-09-05 04:01:55 Re: ERROR: multixact X from before cutoff Y found to be still running