Re: resolving buffer busy waits

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 14 Sep 2003 21:10:38 -0700
Message-ID: <73e20c6c.0309142010.2d407ce@posting.google.com>

cdyke_at_corp.home.nl (Casey) wrote in message news:<8bc6b8d7.0309141409.2e440f6a_at_posting.google.com>...
>
> so w/out a "real" test env i need/want to tread carefully. i expect
> resolving the bbw issue should, hopefully, cascade up and reduce the
> two above it. am curious to hear any suggestions from anyone who has
> seen and conquered a similar situation.
>

hash partition the hot table? That should work in 8.1.7.3 IIRC. Don't forget the indexes as well.

HTH
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Sun Sep 14 2003 - 23:10:38 CDT