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)
Список
Дерево обсуждения
(WIP) VACUUM REWRITE - CLUSTER by ctid Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: (WIP) VACUUM REWRITE - CLUSTER by ctid Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: (WIP) VACUUM REWRITE - CLUSTER by ctid Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Tom Lane <tgl@sss.pgh.pa.us>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Alvaro Herrera <alvherre@commandprompt.com>
Re: New VACUUM FULL Alvaro Herrera <alvherre@commandprompt.com>
Re: New VACUUM FULL Alvaro Herrera <alvherre@commandprompt.com>
Re: New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Tom Lane <tgl@sss.pgh.pa.us>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Tom Lane <tgl@sss.pgh.pa.us>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Tom Lane <tgl@sss.pgh.pa.us>
Re: New VACUUM FULL Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Robert Haas <robertmhaas@gmail.com>
Re: New VACUUM FULL Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Peter Eisentraut <peter_e@gmx.net>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: New VACUUM FULL Robert Haas <robertmhaas@gmail.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Robert Haas <robertmhaas@gmail.com>
Re: New VACUUM FULL Josh Berkus <josh@agliodbs.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Robert Haas <robertmhaas@gmail.com>
Re: New VACUUM FULL Simon Riggs <simon@2ndQuadrant.com>
Re: New VACUUM FULL Tom Lane <tgl@sss.pgh.pa.us>
Re: New VACUUM FULL Robert Haas <robertmhaas@gmail.com>
Re: New VACUUM FULL Josh Berkus <josh@agliodbs.com>
Re: New VACUUM FULL Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: New VACUUM FULL Greg Stark <gsstark@mit.edu>
Re: New VACUUM FULL Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Alvaro Herrera <alvherre@commandprompt.com>
Re: New VACUUM FULL Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>
Re: New VACUUM FULL Josh Berkus <josh@agliodbs.com>
Re: New VACUUM FULL Michael Glaesemann <grzm@seespotcode.net>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
Re: New VACUUM FULL Greg Smith <greg@2ndquadrant.com>
Re: New VACUUM FULL Jeff Davis <pgsql@j-davis.com>
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 по дате отправления
От: Peter Eisentraut
Дата: