| From: | Euler Taveira <euler(at)timbira(dot)com(dot)br> |
|---|---|
| To: | ram(dot)maurya(at)lavainternational(dot)in, 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-05 12:31:38 |
| Message-ID: | CAHE3wgjG6C=Xwr=JEc2HX=XFj_9XUXgzjK=ROPjeDeaUdCA7jg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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.
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Schneider | 2019-09-05 18:32:15 | Re: ERROR: multixact X from before cutoff Y found to be still running |
| Previous Message | Peter Eisentraut | 2019-09-05 12:16:11 | Re: BUG #15977: Inconsistent behavior in chained transactions |