>My question is can I implement it as a single slonik script with 100
>EXECUTE SCRIPT commands and some "wait" between, or do I need to
>implement 100 slonik scripts and execute them within a shell script
>loop and appropriate wait in between.

You can put a pg_sleep(seconds) function in between the ALTERs.eg:
ALTER TABLE some_table1
...
...;

SELECT pg_sleep(300);

ALTER TABLE some_table2
...
...;

Will pause 5 minutes between altering some_table1 and some_table2.

Melvin Davidson 




      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100104/9e0a7c05/attachment.htm