http://blogs.oracle.com/jkshah/entry/how_about_a_postgres_extension http://www.solarisinternals.com/wiki/index.php/ZFS_for_Databases#PostgreSQL_Considerations
On 5/26/2011 10:30 AM, LaoTsao wrote:
What I say may not be upto date If you want performance, mirror and ssd for zil, there exist white paper for zfs and oracle db You may be able to used for postgres If you want sPace raidz give you the most space it use raid5 like protection raidz2 and raidz3 Like double and triple parity to protect more hdd. Failure One more things you need to consider is How are serve the db: nfs, iscsi, fc etc IMHO, nfs is the simplest Iscsi and fc you will need another FS on server for DB Zfs provide analytics(dtrace based) will have you do some realtime data to help you about performance Of course you will need good backup You did not mention you have single head or dual head for 7320 It provide and plus and minus Sent from my iPad Hung-Sheng Tsao ( LaoTsao) Ph.D On May 26, 2011, at 9:09 AM, Gustav Potgieter<g...@phunk.co.za> wrote:Thank you for the reply Sir. I have downloaded the Simulator but as per the attached image it only briefly explains the options, and does not actually go into detail or in real terms explains it. I would like to know if this compares to say RAID 10 if I choose Triple mirrored, or what the best option would be for a database, from google etc I can not see this reference. <configure-7320.png> I have a support contract and I am just waiting for the details, As for optimization, I have already run a lot of tests and I am confident in my config, but would like to know if there was any specific optimization for a 7320 that would be of interest for me. I will most def follow @lisa09, and have posted this into the zfs-discuss section. Hope you have a good day, Gustav On 26 May 2011, at 2:57 PM, LaoTsao wrote:May be you should ask in zfs-discuss list Zfs appliance has simulator that should be able to g.I've you some idea about the tread off for space for various raid/mirror As for performance, google it and read various zfs links , best practice tunning guide Zfs @lisa09 is good start You should get support contract to cover your self Sent from my iPad Hung-Sheng Tsao ( LaoTsao) Ph.D On May 26, 2011, at 7: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? Thanks, all feedback will be appreciated! -- This message posted from opensolaris.org _______________________________________________ sysadmin-discuss mailing list sysadmin-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/sysadmin-discuss
<<attachment: laotsao.vcf>>
_______________________________________________ sysadmin-discuss mailing list sysadmin-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/sysadmin-discuss
