On Mon, Jan 04, 2010 at 03:34:55PM -0500, Vick Khera wrote:
> 
> 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.

Since it's one transaction, you'll be blocked the whole time.

> Perhaps my best strategy will be to run this script on my replica node
> only, swap master, then run it on the old origin using EXECUTE ONLY ON
> parameter.

That sounds like a more promising avenue to me, yes.

A

-- 
Andrew Sullivan
ajs at crankycanuck.ca