Thread: BUG #15992: Index size larger than the base table size. Sometime 3 times large
BUG #15992: Index size larger than the base table size. Sometime 3 times large
From
PG Bug reporting form
Date:
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
Re: BUG #15992: Index size larger than the base table size. Sometime3 times large
From
Euler Taveira
Date:
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
RE: BUG #15992: Index size larger than the base table size. Sometime3 times large
From
Ram Pratap Maurya
Date:
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 yourindex 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
Re: BUG #15992: Index size larger than the base table size. Sometime3 times large
From
Euler Taveira
Date:
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]. [1] https://www.postgresql.org/docs/11/upgrading.html -- Euler Taveira Timbira - http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento