Re: Load spikes on 8.1.11

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Load spikes on 8.1.11
Дата
Msg-id 20080718045116.GC9953@commandprompt.com
обсуждение исходный текст
Ответ на Re: Load spikes on 8.1.11  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Ответы Re: Load spikes on 8.1.11  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Load spikes on 8.1.11
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH]-hash index improving