From: | Ram Pratap Maurya <ram(dot)maurya(at)lavainternational(dot)in> |
---|---|
To: | Euler Taveira <euler(at)timbira(dot)com(dot)br>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | RE: BUG #15992: Index size larger than the base table size. Sometime 3 times large |
Date: | 2019-09-06 05:08:32 |
Message-ID: | PS1PR0601MB36917C8E0E16344101EB9532F0BA0@PS1PR0601MB3691.apcprd06.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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(at)timbira(dot)com(dot)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(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2019-09-06 07:54:15 | Re: BUG #15977: Inconsistent behavior in chained transactions |
Previous Message | Alvaro Herrera | 2019-09-05 23:20:14 | Re: BUG #15383: Join Filter cost estimation problem in 10.5 |