New VACUUM FULL
От | Itagaki Takahiro |
---|---|
Тема | New VACUUM FULL |
Дата | |
Msg-id | 20091027135502.34DE.52131E4D@oss.ntt.co.jp обсуждение исходный текст |
Ответ на | Re: (WIP) VACUUM REWRITE - CLUSTER by ctid (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>) |
Ответы |
Re: New VACUUM FULL
Re: New VACUUM FULL Re: New VACUUM FULL Re: New VACUUM FULL Re: New VACUUM FULL |
Список | pgsql-hackers |
Here is a patch to support "rewrite" version of VACUUM FULL. It was called "VACUUM REWRITE" in the past disucussin, but I choose the following syntax for now: VACUUM ( FULL [ INPLACE | REPLACE ] ) [ table_name ] The reason is to contrast the new REPLACE behavior with the old INPLACE behavior. I cannot find any good terms of opposite meaning of REWRITE. The new version works like as CLUSTER USING ctid or rewriting in ALTER TABLE. It must be faster than them if we have many dead tuples and are not interested in physical order of tuples. We still need traditional VACUUM FULL behavior for system catalog because we cannot change relfilenode for them. Also, VACUUM FULL REPLACE is not always better than traditional VACUUM FULL; the new version requires additional disk space and might be slower if we have a few dead tuples. "VACUUM FULL" and "VACUUM (FULL)" are synonyms for "VACUUM (FULL REPLACE)", but if the target table is s system catalog, instead "FULL INPLACE" is used automatically. If this approach is reasonable, I'll go for other supplemental parts. (documentations, vacuumdb, etc.) Regards, --- ITAGAKI Takahiro NTT Open Source Software Center
Вложения
В списке pgsql-hackers по дате отправления: