Dimitri escribió: > Folks, > > is there any constrains/problems/etc. to run several vacuum processes in > parallel while each one is 'vaccuming' one different table?
No, no problem. Keep in mind that if one of them takes a very long time, the others will not be able to remove dead tuples that were killed while the long vacuum was running -- unless you are in 8.2. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match