<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">>My question is can I implement it as a single slonik script with 100<br>>EXECUTE SCRIPT commands and some "wait" between, or do I need to<br>>implement 100 slonik scripts and execute them within a shell script<br>>loop and appropriate wait in between.<br><br>You can put a <span style="font-family: monospace;">pg_sl<span style="font-family: arial;">eep(seconds) function in between the ALTERs.</span></span><pre class="SYNOPSIS">eg:<br>ALTER TABLE some_table1<br>...<br>...;<br><br>SELECT pg_sleep(300);<br><br>ALTER TABLE some_table2<br>...<br>...;<br><br>Will pause 5 minutes between altering some_table1 and some_table2.<br><br></pre><font size="4"><span style="font-weight: bold; font-family: arial; color: rgb(0, 0, 255);">Melvin Davidson </span></font><br><br></td></tr></table><br>