add -s to vacuumdb

On 05/05/2015 03:06 PM, Joshua D. Drake wrote:

Hey folks,

Just had your standard... our pg_ tables are all bloated out, what is
a good way to take care of that. We have -s for reindexdb but not
vacuumdb. Thoughts?

What command will it run? VACUUM doesn't have a SYSTEM flag, unlike REINDEX

cheers

andrew

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On 05/05/2015 12:22 PM, Andrew Dunstan wrote:

On 05/05/2015 03:06 PM, Joshua D. Drake wrote:

Hey folks,

Just had your standard... our pg_ tables are all bloated out, what is
a good way to take care of that. We have -s for reindexdb but not
vacuumdb. Thoughts?

What command will it run? VACUUM doesn't have a SYSTEM flag, unlike REINDEX

The equivalent of:

vacuum (FULL/VERBOSE/ANALYZE/FREEZE) pg_*

Just like REINDEX/reindexdb

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On Tue, May 5, 2015 at 4:26 PM, Joshua D. Drake <jd@commandprompt.com>
wrote:

On 05/05/2015 12:22 PM, Andrew Dunstan wrote:

On 05/05/2015 03:06 PM, Joshua D. Drake wrote:

Hey folks,

Just had your standard... our pg_ tables are all bloated out, what is
a good way to take care of that. We have -s for reindexdb but not
vacuumdb. Thoughts?

What command will it run? VACUUM doesn't have a SYSTEM flag, unlike

REINDEX

The equivalent of:

vacuum (FULL/VERBOSE/ANALYZE/FREEZE) pg_*

Just like REINDEX/reindexdb

IMHO isn't difficult to add a --system option to vacuumdb and would be
nice to have a --schema option too.

Some time ago I proposed to add SCHEMA option to VACUUM command [1]/messages/by-id/CAFcNs+pHJLmLM9n=B6aofV3XPpwHq+znnEjV9UkvPNSZyegXow@mail.gmail.com but it
was not very well accepted and the better way is add more options to
vacuumdb. I started a patch to add more powers to --tables option to
vacuumdb but unfortunately I had no time to finish it.

I know it's another thing but the internal refactoring in vacuumdb to
support it enable us to add --system and --schema options also.

Regards,

[1]: /messages/by-id/CAFcNs+pHJLmLM9n=B6aofV3XPpwHq+znnEjV9UkvPNSZyegXow@mail.gmail.com
/messages/by-id/CAFcNs+pHJLmLM9n=B6aofV3XPpwHq+znnEjV9UkvPNSZyegXow@mail.gmail.com

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL