Re: slony issues. - Mailing list pgsql-general

From Jeff Davis
Subject Re: slony issues.
Date
Msg-id 1257620776.27737.598.camel@jdavis
Whole thread Raw
In response to Re: slony issues.  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Sat, 2009-11-07 at 11:59 -0700, Scott Marlowe wrote:
> Thanks I'll take a look.  I'm afraid that I might not get much out of
> it if the cost is hidden by the function.  But it's a start.

You should be able to get the cost of any SPI executed in the function
by using auto_explain.log_nested_statements. Other activity may be
hidden, but I can't think of something else that a function in slony
would spend a lot of time doing.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: slony issues.
Next
From: Christian Petzold
Date:
Subject: pgp encryption functions