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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general