Postgres Pro
Downloads
Home   >   mailing lists

Re: vacuumdb for schema only - Mailing list pgsql-admin

From Bèrto ëd Sèra
Subject Re: vacuumdb for schema only
Date
Msg-id AANLkTi=-e5RNzSgBsny80eCac=eLLWomhh0KsqviKeJX@mail.gmail.com
Whole thread Raw
In response to Re: vacuumdb for schema only  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: vacuumdb for schema only  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-admin
Tree view
Hi!

I would also expect you to be able to make a Stored Procedure executing the same command, although I never tried it myself.

Bèrto

On 8 September 2010 03:17, Fabrízio de Royes Mello <fabriziomello@gmail.com> wrote:

2010/9/7 Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>

Hi List,
I would like to know if there is an option to run full vacuumdb  for a specific schema only, I see there is  option for tables or whole db .


No, but you can do like this using "psql" :

psql -U postgres -t -A -c "select 'VACUUM '||table_schema||'.'||table_name||';' from information_schema.tables where table_schema = 'public'" bdteste | psql -U postgres bdteste

The example above will run VACUUM to all tables in schema called 'public' in 'bdteste' database.

Best regards,

--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com



--
==============================
Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les droits du peuple, l'insurrection est, pour le peuple et pour chaque portion du peuple, le plus sacré des droits et le plus indispensable des devoirs.

pgsql-admin by date:

Previous
From: Jesper Krogh
Date:
Subject: Re: [NOVICE] - SAN/NAS/DAS - Need advises
Next
From: Thomas Uzunoff
Date:
Subject: PostgreSQL article online - PDF