Thread: Custom vacuum
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.
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
Fábio Henrique Gibon
Comex System Consultoria
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?
psql -U postgres -A -t your_database_name -c "SELECT 'VACUUM '||tablename||';' FROM mytablesvacuum" | psql -U postgres your_database_name