On 08 November 2013 13:38, Jan Lentfer
> For this use case, would it make sense to queue work (tables) in order of > their size, starting on the largest one? > For the case where you have tables of varying size this would lead to a > reduced overall processing time as it prevents large (read: long processing > time) tables to be processed in the last step. While processing large tables > at first and filling up "processing slots/jobs" when they get free with > smaller tables one after the other would safe overall execution time. Good point, I have made the change and attached the modified patch. Regards, Dilip
vacuumdb_parallel_v2.patch
Description: vacuumdb_parallel_v2.patch
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers