On Wednesday 26 March 2008 16:03, hubert depesz lubaczewski wrote:
> On Wed, Mar 26, 2008 at 10:02:45AM -0700, Steve Atkins wrote:
> > What's the psql equivalent of the "standard" use case of "vacuumdb -a"?
> > (If you don't know the answer, for both unix and windows, you don't get
> > to vote for removing vacuumdb).
>
> linux:
> psql -qAt -c "select E'\\\\connect ' || datname || E'\nvacuum;' from
> pg_database where datallowconn" | psql
>
> windows:
> psql -qAt -c "select E'\\connect ' || datname || E'\nvacuum;' from
> pg_database where datallowconn" | psql
>
> that's not actually complicated (i'm not saying it's nice, as it isn't).
>
I have to think that a better solution for someone whose needs are met by the
above is to just enable autovacuum.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL