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

From Gurjeet Singh
Subject Re: Load spikes on 8.1.11
Date
Msg-id 65937bea0807172211q3cbeb504k99ff0d6369a31378@mail.gmail.com
Whole thread Raw
In response to Re: Load spikes on 8.1.11  (Andrew Sullivan <ajs@commandprompt.com>)
Responses Re: Load spikes on 8.1.11  (Andrew Sullivan <ajs@commandprompt.com>)
List pgsql-hackers
On Fri, Jul 18, 2008 at 10:21 AM, Andrew Sullivan <ajs@commandprompt.com> wrote:
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.


I am in the eye of the storm right now.

Just started INIT cluster Slonik command and that spiked too.. for more than 10 minutes now!!


--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB http://www.enterprisedb.com

Mail sent from my BlackLaptop device

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCH]-hash index improving
Next
From: "Pavel Stehule"
Date:
Subject: Re: TABLE-function patch vs plpgsql