On Sat, 2009-11-07 at 09:23 -0700, Scott Marlowe wrote:
> I already asked this basic question on the slony mailing lists, but
> they seem kinda quiet this week.
>
> So, I've got a database with about 30,000 objects in it, and running
> the setaddtable() function is taking about 30 seconds, and spinning a
> CPU 100% while doing it.
auto_explain may be able to help. It can automatically collect slow
queries and provide explain analyze output, even for queries inside
functions.
Regards,
Jeff Davis