BUG #15992: Index size larger than the base table size. Sometime 3 times large

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15992: Index size larger than the base table size. Sometime 3 times large

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15992
Logged by:          Ram Pratap Maurya
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15992: Index size larger than the base table size. Sometime 3 times large

Euler Taveira
Em qui, 5 de set de 2019 às 08:18, PG Bug reporting form
<[hidden email]> 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


Reply | Threaded
Open this post in threaded view
|

RE: BUG #15992: Index size larger than the base table size. Sometime 3 times large

Ram Pratap Maurya
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:[hidden email]]
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: BUG #15992: Index size larger than the base table size. Sometime 3 times large

Euler Taveira
Em sex, 6 de set de 2019 às 02:08, Ram Pratap Maurya
<[hidden email]> 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