On Thu, May 26, 2011 at 8:13 AM, Gustav <g...@phunk.co.za> wrote:

> Hi All,
>
> Can someone please give some advise on the following?
>
> We are installing a 7320 with 2 18 GB Write Accelerators, 20 x 1 TB disks
> and 96 GB of ram.
>
> Postgres will be running on a Oracle x6270 device with 96GB of ram
> installed and two quad core cpus, with a local WALL on 4 hard drives, and
> 7320 LUN via 8GB FC.
>
> I am going configure the 7320 as Mirrored with the following options
> available to me (read and write cache enabled):
> Double parity RAID
> Mirrored
> Single partiy RAID, narrow stripes
> Striped
> Triple mirrored
>
> Was does the above mean in real terms officially,
> and what is optimum for a (Postgresql 9, or any performance tips for
> Postgres on a 7320) database high writes,
> and are there any comments that can help us improve performance?
>


Hello,

 I would advise against creating many small pools of disks unless you've
very different capacity/performance/reliability requeriments. Even then, try
to limit the number of pools as much as you can. I know newer firmwares
allowed you to create 2 pools but I guess they removed that limitation (but
still advise against it). Check the documentation in the "Help" link within
the appliance, it's usually very detailed.

 Alghouth the 7320 is an appliance and comes with its own documentation, I
think you'd benefit from reading the ZFS Best Practices Guide (
http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide).

 You're probably looking for maximum performance with availability so that
narrows it down to a mirrored pool, unless your Postgresql workload is very
specific that raidz would fit, but beware of the performance hit.

Regards,

-- 
Giovanni Tirloni
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss

Reply via email to