BUG #16002: Index size larger than the base table size and growing abnormally.

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 #16002: Index size larger than the base table size and growing abnormally.
Date: 2019-09-12 05:38:17
Message-ID: 16002-5d85577f4ecca49c@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16002
Logged by: ram pratap maurya
Email address: ram(dot)maurya(at)lavainternational(dot)in
PostgreSQL version: 11.0
Operating system: RHEL 7

Hi Team,

We are facing problem with our database growth though growth of the tables
is not at all concenred but index sizes are getting increased abnormally and
couple of tables are having 3 times larger indexes.

Could you please let us know what can be the root cause of this problem.
Platform details are as follows.

Postgres Database - 11.0
Index Type Used - B-Tree

Please le us know if further information is required from our end to resolve
this problem.

Ram Pratap

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-09-12 08:40:11 BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty
Previous Message Tom Lane 2019-09-11 15:47:07 Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND