vacuumdb for a number of tables

From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuumdb for a number of tables
Date: 2007-08-20 18:38:10
Message-ID: 1187635090.741747.9110@d55g2000hsg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi!

I want to vacuum analyze a number of tables in a given database (on
port 5432) from a shell script. There is no need to process the whole
database.
Using
vacuumdb -d mydb -t mytab1 -t mytab2 -t mytab3 -fzp 5432;
silently operates on the last tablename given only. 'mytab3' in the
example above.

So, is this the only way to do it, or am I missing something?
vacuumdb -d mydb -t mytab1 -fzp 5432
vacuumdb -d mydb -t mytab2 -fzp 5432
vacuumdb -d mydb -t mytab3 -fzp 5432

Regards
Erwin

Browse pgsql-admin by date

  From Date Subject
Next Message Jessica Richard 2007-08-20 20:03:14 server closed the connection unexpectedly
Previous Message Juliann Meyer 2007-08-20 18:33:52 vacuum questions