<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Apr 16, 2013 at 9:10 AM, Vick Khera <span dir="ltr"><<a href="mailto:vivek@khera.org" target="_blank">vivek@khera.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">So my instinct is that there is some change in 9.2 that slony is tripping over that is causing it to lock something for way too long. I would appreciate any guidance on figuring out what that is, so I can avoid having long delays in my replication while vacuum is running.</blockquote>
</div><br>Hmmm... I just realized that there is a pg_dump that starts at about 3am. I wonder of that's the cause, and not slony/vacuum interaction after all. I will experiment by changing the time of the vacuum tonight.</div>
</div>