Re: Index bloat of 4x
От
Bill Moran
Тема
Re: Index bloat of 4x
Дата
Msg-id
20070117125203.899f6660.wmoran@collaborativefusion.com
Ответ на
Re: Index bloat of 4x (Alvaro Herrera)
Список
Дерево обсуждения
Index bloat of 4x Bill Moran <wmoran@collaborativefusion.com>
Re: Index bloat of 4x "Greg Sabino Mullane" <greg@turnstep.com>
Re: Index bloat of 4x Csaba Nagy <nagy@ecircle-ag.com>
Re: Index bloat of 4x Alvaro Herrera <alvherre@commandprompt.com>
Re: Index bloat of 4x Bill Moran <wmoran@collaborativefusion.com>
Re: Index bloat of 4x Alvaro Herrera <alvherre@commandprompt.com>
Re: Index bloat of 4x Bill Moran <wmoran@collaborativefusion.com>
Re: Index bloat of 4x Tom Lane <tgl@sss.pgh.pa.us>
Re: Index bloat of 4x Bill Moran <wmoran@collaborativefusion.com>
Re: Index bloat of 4x "Ed L." <pgsql@bluepolka.net>
Re: Index bloat of 4x Csaba Nagy <nagy@ecircle-ag.com>
Re: Index bloat of 4x "Ed L." <pgsql@bluepolka.net>
Re: Index bloat of 4x Tom Lane <tgl@sss.pgh.pa.us>
Re: Index bloat of 4x "Jeremy Haile" <jhaile@fastmail.fm>
Re: Index bloat of 4x Csaba Nagy <nagy@ecircle-ag.com>
Re: Index bloat of 4x "Ed L." <pgsql@bluepolka.net>
Re: Index bloat of 4x Bruce Momjian <bruce@momjian.us>
Re: Index bloat of 4x Jim Nasby <decibel@decibel.org>
Re: Index bloat of 4x Alvaro Herrera <alvherre@commandprompt.com>
Re: Index bloat of 4x Bruce Momjian <bruce@momjian.us>
Re: Index bloat of 4x Tom Lane <tgl@sss.pgh.pa.us>
Re: Index bloat of 4x Bruce Momjian <bruce@momjian.us>
Re: Index bloat of 4x Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Re: Index bloat of 4x Vivek Khera <vivek@khera.org>
In response to Alvaro Herrera : > Bill Moran wrote: > > > The entire database was around 28M prior to the upgrades, etc. Immediately > > after the upgrades, it was ~270M. Following a vacuum full, it dropped to > > 165M. Following a database-wide reindex, it dropped to 30M. > > Oh, so it was clearly the upgrade procedure that caused the bloat ... > Reindexing seems the expected course. Right. Sorry if I didn't explain that properly. It wasn't the fact that it bloated that surprised me. It was the _magnitude_ of bloat that I wasn't expecting, as well as the fact that it was _all_ _index_ bloat. -- Bill Moran Collaborative Fusion Inc.
В списке pgsql-general по дате отправления
От: novnov
Дата:
