BUG #15992: Index size larger than the base table size. Sometime 3 times large
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
Em qui, 5 de set de 2019 às 08:18, PG Bug reporting form
<noreply@postgresql.org> escreveu:
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.
This is not a bug. You don't provide enough information to show us
that behavior so I can't comment on it.Depending on your index method
(B-tree, hash, GiST, SP-GiST, GIN, and BRIN), index size can be bigger
and grows quickly.
psql version 8.4, server version 11.0.
Why aren't you using psql 11? Also, 11.5 is out. You are missing
dozens of important bug fixes.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Dear team,
We are using B-tree index and can you suggest how to upgrade psql from version 8.4 to 11.
Regards,
Ram Pratap.
Lava International Limited.
Tel+ 91-120-4637148
-----Original Message-----
From: Euler Taveira [mailto:euler@timbira.com.br]
Sent: 05 September 2019 18:02
To: Ram Pratap Maurya; PostgreSQL mailing lists
Subject: Re: BUG #15992: Index size larger than the base table size. Sometime 3 times large
Em qui, 5 de set de 2019 às 08:18, PG Bug reporting form <noreply@postgresql.org> escreveu:
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.
when i run full vacuum , index size is decrease but again increase
after a week.
This is not a bug. You don't provide enough information to show us that behavior so I can't comment on it.Depending on your index method (B-tree, hash, GiST, SP-GiST, GIN, and BRIN), index size can be bigger and grows quickly.
psql version 8.4, server version 11.0.
Why aren't you using psql 11? Also, 11.5 is out. You are missing dozens of important bug fixes.
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
Em sex, 6 de set de 2019 às 02:08, Ram Pratap Maurya
<ram.maurya@lavainternational.in> escreveu:
We are using B-tree index and can you suggest how to upgrade psql from version 8.4 to 11.
Read "Upgrading a PostgreSQL Cluster" [1]https://www.postgresql.org/docs/11/upgrading.html.
[1]: https://www.postgresql.org/docs/11/upgrading.html
--
Euler Taveira Timbira -
http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento