Re: New VACUUM FULL - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: New VACUUM FULL
Date
Msg-id 20091113104715.12B0.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: New VACUUM FULL  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: New VACUUM FULL
Re: New VACUUM FULL
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> wrote:

> BTW I think the vacstmt.options change, which seems a reasonable idea to
> me, could be extracted from the patch and applied separately.  That'd
> reduce the size of the patch somewhat.

It's a good idea. I separated the part into the attached patch.
It replaces VacuumStmt's "vacuum", "full", "analyze", and "verbose"
fields into one "options" flag field.

The only user-visible change is to support "VACUUM (options)" syntax:
  VACUUM ( FULL, FREEZE, VERBOSE, ANALYZE ) table (columns)
We don't bother with the order of options in this form :)

There is a debatable issue that we can use "VACUUM (VERBOSE) table (col)"
in the abobe syntax. Columns are specified but no ANALYZE option there.
An ANALYZE option is added automatically in the current implementation,
but we should have thrown an syntax error in such case.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center


Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Patch committers
Next
From: Fujii Masao
Date:
Subject: Re: write ahead logging in standby (streaming replication)