Re: BUG #15992: Index size larger than the base table size. Sometime3 times large
| От | Euler Taveira |
|---|---|
| Тема | Re: BUG #15992: Index size larger than the base table size. Sometime3 times large |
| Дата | |
| Msg-id | CAHE3wgjG6C=Xwr=JEc2HX=XFj_9XUXgzjK=ROPjeDeaUdCA7jg@mail.gmail.com обсуждение исходный текст |
| Ответ на | BUG #15992: Index size larger than the base table size. Sometime 3 times large (PG Bug reporting form <noreply@postgresql.org>) |
| Ответы |
RE: BUG #15992: Index size larger than the base table size. Sometime3 times large
|
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: