Re: automatic REINDEX-ing
От | William Garrison |
---|---|
Тема | Re: automatic REINDEX-ing |
Дата | |
Msg-id | 48A1B5CE.8030201@mobydisk.com обсуждение исходный текст |
Ответ на | Re: automatic REINDEX-ing (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: automatic REINDEX-ing
|
Список | pgsql-general |
Tom Lane wrote: > Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com> writes: > >> I executed REINDEX by hand and the disk ocupation imediatelly dropped 6 >> Giga...!!! >> > > >> is there a way to configure postgres to automatically execute the needed >> REINDEXING (on indexes and tables) for a given database.... >> > > Generally speaking, there shouldn't be a need for "automatic > reindexing". What the above suggests is that you need more aggressive > routine vacuuming, so that you don't get into this situation in the > first place. > > BTW, "more aggressive routine vacuuming" does NOT mean "use vacuum full". > Vacuum full tends to make index bloat worse, not better. > > regards, tom lane > > So now that we know what that term does not mean, what does it mean? Just doing it more often by adjusting the autovacuum parameters?
В списке pgsql-general по дате отправления: