Re: [HACKERS] (WIP) VACUUM REWRITE - CLUSTER by ctid

2009-10-25 Thread Itagaki Takahiro
Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: I got the impression that replacing VACUUM FULL is the most popular opinion. I like VACUUM REWRITE myself, except that it would require making REWRITE a reserved keyword. My next proposal for the syntex is VACUUM (options)

Re: [HACKERS] (WIP) VACUUM REWRITE - CLUSTER by ctid

2009-10-23 Thread Heikki Linnakangas
Itagaki Takahiro wrote: I'm working on alternative version of VACUUM FULL, which is like CLUSTER but sort tuples in ctid order without index. The original discussion is here: [HACKERS] Feedback on getting rid of VACUUM FULL

[HACKERS] (WIP) VACUUM REWRITE - CLUSTER by ctid

2009-10-22 Thread Itagaki Takahiro
I'm working on alternative version of VACUUM FULL, which is like CLUSTER but sort tuples in ctid order without index. The original discussion is here: [HACKERS] Feedback on getting rid of VACUUM FULL http://archives.postgresql.org/pgsql-hackers/2009-09/msg01047.php WIP patch attached. I