>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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
