Re: Load spikes on 8.1.11 - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: Load spikes on 8.1.11
Date
Msg-id 20080718045116.GC9953@commandprompt.com
Whole thread Raw
In response to Re: Load spikes on 8.1.11  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Responses Re: Load spikes on 8.1.11  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
List pgsql-hackers
On Fri, Jul 18, 2008 at 10:05:33AM +0530, Gurjeet Singh wrote:

> I just ran DROP SCHEMA _<slony schema> CASCADE; and it spiked again, on a
> very low loaded box!!

Ah, well, if slony is involved, then you have possible locking
problems in the database _also_ to contend with, along with the
spinlock problems.  This will for sure cause spikes.

You need to tell us more about what you're doing.  And I bet some of
it belongs on the slony lists.

A
-- 
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Load spikes on 8.1.11
Next
From: Tom Lane
Date:
Subject: Re: [PATCH]-hash index improving