Re: slony issues.

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: slony issues.
Date: 2009-11-07 17:57:05
Message-ID: 1257616625.27737.577.camel@jdavis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-11-07 18:59:51 Re: slony issues.
Previous Message Scott Marlowe 2009-11-07 16:23:55 slony issues.