Re: Is there any other way to do this?

От: Steinar H. Gunderson
Тема: Re: Is there any other way to do this?
Дата: ,
Msg-id: 20050517225726.GA24185@uio.no
(см: обсуждение, исходный текст)
Ответ на: Is there any other way to do this?  (Wei Weng)
Список: pgsql-performance

On Tue, May 17, 2005 at 06:58:20PM -0400, Wei Weng wrote:
> This time it worked! But VACUUM FULL requires an exclusive lock on the
> table which I don't really want to grant. So my question is: why is VACUUM
> ANALYZE didn't do the job? Is there any setting I can tweak to make a
> VACUUM without granting a exclusive lock?

You just didn't vacuum often enough. Plain VACUUM (with ANALYZE or not) only
deletes dead rows, it does not reclaim the space used for them (and thus does
not compress the remaining ones into fewer pages, so they take less time to
scan). If you simply VACUUM regularily (try autovacuum from contrib, it will
probably be useful) the problem simply will never be as bad as you describe
here, and you won't need to VACUUM FULL.

/* Steinar */
--
Homepage: http://www.sesse.net/


В списке pgsql-performance по дате сообщения:

От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Is there any other way to do this?
От: Szűcs Gábor
Дата:
Сообщение: where+orderby+limit not (always) using appropriate index?