Re: postgresql performance tuning
От
Michael Stone
Тема
Re: postgresql performance tuning
Дата
Msg-id
20051207002307.GM7330@mathom.us
Ответ на
Re: postgresql performance tuning (Ameet Kini)
Список
Дерево обсуждения
postgresql performance tuning Ameet Kini <akini@cs.wisc.edu>
Re: postgresql performance tuning Vivek Khera <vivek@khera.org>
Re: postgresql performance tuning Alan Stange <stange@rentec.com>
Re: postgresql performance tuning Tom Lane <tgl@sss.pgh.pa.us>
Re: postgresql performance tuning Alan Stange <stange@rentec.com>
Re: postgresql performance tuning Ameet Kini <akini@cs.wisc.edu>
Re: postgresql performance tuning Michael Stone <mstone+postgres@mathom.us>
slow COMMITs Evgeny Gridasov <eugrid@fpm.kubsu.ru>
Re: postgresql performance tuning Vivek Khera <vivek@khera.org>
On Tue, Dec 06, 2005 at 04:03:22PM -0600, Ameet Kini wrote: >I'm running postgresql v8.0 and my problem is that running vacuum on my >indices are blazing fast (upto 10x faster) AFTER running reindex. For a >table with only 1 index, the time to do a vacuum (without full) went down >from 45 minutes to under 3 minutes. I've also noticed a fairly large increase in vacuum speed after a reindex. (To the point where the reindex + vacuum was faster than just a vacuum.) Mike Stone
В списке pgsql-performance по дате отправления
