Skip site navigation (1) Skip section navigation (2)

Re: COUNT(*) дофига весит

From: Alex Gorbachenko <agent_007(at)immo(dot)ru>
To: pgsql-ru-general(at)postgresql(dot)org
Subject: Re: COUNT(*) дофига весит
Date: 2008-04-17 06:37:17
Message-ID: 20080417103717.303f9d80@satellite.immo (view raw or flat)
Thread:
Lists: pgsql-ru-general
On Wed, 16 Apr 2008 13:48:42 +0400
silly_sad wrote:

>Объясните пожалуйста, в чем разница между авто и еженочным vaccuum
>analyze?

в том, что autovacuum проверяет количество измененных
записей в таблицах, и запускается в случае, если это количество >
некоего числа. что позволяет "размазать" вакуум по времени. по моему в
документации это написано довольно подробно.

цитата:

"When enabled, the autovacuum daemon runs periodically and checks for
tables that have had a large number of inserted, updated or deleted
tuples."

"Tables whose relfrozenxid value is more than autovacuum_freeze_max_age
transactions old are always vacuumed. Otherwise, two conditions are
used to determine which operation(s) to apply. If the number of
obsolete tuples since the last VACUUM exceeds the "vacuum threshold",
the table is vacuumed."

-- 
np: Alter Bridge - Before Tomorrow Comes

In response to

Responses

pgsql-ru-general by date

Next:From: silly_sadDate: 2008-04-17 07:24:32
Subject: Re: COUNT(*) дофига весит
Previous:From: Alex GorbachenkoDate: 2008-04-17 06:31:09
Subject: Re: COUNT(*) дофига весит

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group