From: | Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com> |
---|---|
To: | fabriziomello(at)gmail(dot)com |
Cc: | isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)ca, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: vacuumdb for schema only |
Date: | 2010-09-08 05:34:11 |
Message-ID: | AANLkTi=-e5RNzSgBsny80eCac=eLLWomhh0KsqviKeJX@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)com>wrote:
>
> 2010/9/7 Isabella Ghiurea <isabella(dot)ghiurea(at)nrc-cnrc(dot)gc(dot)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
> >> Perfil Linkedin: http://br.linkedin.com/in/fabriziomello
>
>
--
==============================
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Uzunoff | 2010-09-08 08:44:14 | PostgreSQL article online - PDF |
Previous Message | Jesper Krogh | 2010-09-08 04:58:42 | Re: [NOVICE] - SAN/NAS/DAS - Need advises |