Postgres Pro
Downloads
Home   >   mailing lists

BUG #15992: Index size larger than the base table size. Sometime 3 times large - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15992: Index size larger than the base table size. Sometime 3 times large
Date
Msg-id 15992-4e76de596b6855be@postgresql.org
Whole thread Raw
Responses Re: BUG #15992: Index size larger than the base table size. Sometime3 times large
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15992
Logged by:          Ram Pratap Maurya
Email address:      ram.maurya@lavainternational.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

pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: ERROR: multixact X from before cutoff Y found to be still running
Next
From: Euler Taveira
Date:
Subject: Re: BUG #15992: Index size larger than the base table size. Sometime3 times large