Re: Proposal "VACUUM SCHEMA" - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Proposal "VACUUM SCHEMA"
Date
Msg-id 20141222171107.GE1768@alvh.no-ip.org
Whole thread Raw
In response to Re: Proposal "VACUUM SCHEMA"  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Stephen Frost wrote:
> * Alvaro Herrera (alvherre@2ndquadrant.com) wrote:

> > Overall, this whole line of development seems like bloating the parse
> > tables for little gain.
> 
> Still, I see this point also.  I do think it'd be really great if we
> could figure out a way to segregate these kinds of DDL / maintenance
> commands from the normal select/insert/update/delete SQL parsing, such
> that we could add more options, etc, to those longer running and less
> frequent commands without impacting parse time for the high-volume
> commands.

We do have a parenthesized options clause in VACUUM.  I think adding
this as a clause there would be pretty much free.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Proposal "VACUUM SCHEMA"
Next
From: Stephen Frost
Date:
Subject: Re: Proposal "VACUUM SCHEMA"