pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Custom vacuum 2+ messages / 2 participants [nested] [flat]
* Custom vacuum @ 2010-07-20 18:34 Fábio Gibon - Comex System <gibon@comexsystem.com.br> 2010-07-21 12:16 ` Re: Custom vacuum Fabrízio de Royes Mello <fabriziomello@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Fábio Gibon - Comex System @ 2010-07-20 18:34 UTC (permalink / raw) To: pgsql-admin 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? tks Fábio Henrique Gibon Comex System Consultoria ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Custom vacuum 2010-07-20 18:34 Custom vacuum Fábio Gibon - Comex System <gibon@comexsystem.com.br> @ 2010-07-21 12:16 ` Fabrízio de Royes Mello <fabriziomello@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Fabrízio de Royes Mello @ 2010-07-21 12:16 UTC (permalink / raw) To: Fábio Gibon - Comex System <gibon@comexsystem.com.br>; +Cc: pgsql-admin 2010/7/20 Fábio Gibon - Comex System <gibon@comexsystem.com.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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-07-21 12:16 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2010-07-20 18:34 Custom vacuum Fábio Gibon - Comex System <gibon@comexsystem.com.br> 2010-07-21 12:16 ` Fabrízio de Royes Mello <fabriziomello@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox