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_sta
On Sat, Nov 7, 2009 at 10:57 AM, Jeff Davis wrote:
> 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
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 spi
