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:
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.comReceived on Tue Jan 11 2011 - 21:24:28 CST