Andrew,

> The Packer Solaris database book (Packer, Allan N., _Configuring &
> Tuning Databases on the Solaris Platform_.  Palo Alto: Sun
> Microsystems P, 2002.  ISBN 0-13-083417-3) does suggest mounting the
> filesystems with forcedirectio; I dimly recall using this for the wal
> partition on one test box, and STR that it helped.

This is a good idea for a WAL partition, but is NOT a good idea for the 
database.

You pay want to look into setting segmap_percent to 70% or something.   On 
Solaris 10 at least, the OS by default only uses 10% of memory for disk 
buffers.   

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to