Re: help: high "gc busy buffer"

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 12 Jan 2011 03:24:28 +0000 (UTC)
Message-ID: <pan.2011.01.12.03.24.28_at_gmail.com>



On Tue, 11 Jan 2011 14:15:37 -0800, charles wrote:

> All the "gc buffer busy" points to one small table, no index/triggers on
> this table, which 2000 update, 1800 insert, 1600 select. The table is
> created in a ASSM tablespace, so i guess freelist is not going to help
> here.
>
> Could somebody give me some advice?

Yes, I can give you the advice. The advice is called "functional partitioning". You should make sure that no table is being heavily updated from more than 1 node at any given time.

-- 
http://mgogala.byethost5.com
Received on Tue Jan 11 2011 - 21:24:28 CST

Original text of this message