Steve Atkins wrote:
> What's the psql equivalent of the "standard" use case of "vacuumdb -a"?
There isn't a good one. A tool, possibly a psql option, to do "run this SQL
command in all databases", would allow us to get rid of clusterdb, reindexdb,
vacuumdb.
--
Sent via pgsql-general mailing l
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
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 ' || datnam
On Mar 26, 2008, at 9:37 AM, björn lundin wrote:
1) What type of names do you prefer?
d) remove them - psql is the solution
2) How often do you use these tools?
a) every day (e.g. in my cron)
3) What name of initdb do you prefer?
d) pg_ctl -d init (replace initdb with pg_ctl new
function
> 1) What type of names do you prefer?
> d) remove them - psql is the solution
>
> 2) How often do you use these tools?
> a) every day (e.g. in my cron)
> 3) What name of initdb do you prefer?
> d) pg_ctl -d init (replace initdb with pg_ctl new functionality)
> 4) How do you perform VACUUM?
> a
