From: | Fabrízio de Royes Mello <fabriziomello(at)gmail(dot)com> |
---|---|
To: | Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br> |
Cc: | PostgreSQL - mailing list <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Custom vacuum |
Date: | 2010-07-21 12:16:51 |
Message-ID: | AANLkTikucolWEip6lA27dQzcVRCwgmTT_HO3iFVCr196@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2010/7/20 Fábio Gibon - Comex System <gibon(at)comexsystem(dot)com(dot)br>
> I want perform VACUUM on specific tables. This tables are result of query
> in my database (select tablename from mytablesvacuum). I tryed use a cursor
> on function, but i receive message that vacuun can't run in function.
>
> Any idea to do this?
>
>
Try this:
psql -U postgres -A -t your_database_name -c "SELECT 'VACUUM
'||tablename||';' FROM mytablesvacuum" | psql -U postgres your_database_name
Best regards,
--
Fabrízio de Royes Mello
>> Blog sobre TI: http://fabriziomello.blogspot.com
From | Date | Subject | |
---|---|---|---|
Next Message | a f | 2010-07-22 13:41:03 | Restore a backup to a different disk? |
Previous Message | Robert Voinea | 2010-07-21 05:56:14 | Re: Weird sorting order |