Re: [osol-discuss] Performance of opensolaris

2009-08-02 Thread Anon Y Mous
You could also try posting some of the information from this thread in the performance forum at opensolaris.org : http://www.opensolaris.org/jive/forum.jspa?forumID=26 and maybe you'll get more responses. -- This message posted from opensolaris.org ___

Re: [osol-discuss] Performance of opensolaris

2009-08-02 Thread Anon Y Mous
Bruno: Check out these links: http://blogs.sun.com/jkshah/entry/postgres_on_opensolaris_using_quad http://blogs.sun.com/jkshah/entry/igen_with_postgresql_8_4 http://blogs.sun.com/jkshah/entry/thundering_herd_of_elephants_for http://blogs.sun.com/jkshah/entry/postgres_8_4_locksta

Re: [osol-discuss] Performance of opensolaris

2009-08-02 Thread Bruno Damour
Le 31/07/09 08:37, Zdenek Kotala a écrit : Hello, The main problem with databasases on ZFS is that ZFS does not like synchronous writes. If you want to use ZFS for PostgreSQL or any other database you need tune ZFS and PostgreSQL configuration Thanks for your kind attention, I already red so

Re: [osol-discuss] Performance of opensolaris

2009-07-30 Thread Zdenek Kotala
Hello, The main problem with databasases on ZFS is that ZFS does not like synchronous writes. If you want to use ZFS for PostgreSQL or any other database you need tune ZFS and PostgreSQL configuration. Easiest way is to put XLOG on the separate UFS disk mounted with diretio. If you want to use ZFS

Re: [osol-discuss] Performance of opensolaris

2009-07-30 Thread Scott N.
> If you look closely at Scott's posts, you'll see that > build 110 of OpenSolaris was 3000% faster than build > 109 on the particular benchmark he was running. No, build *118* was 3000% faster than 110. And double from 2008.11 release (109?). -- This message posted from opensolaris.org ___

Re: [osol-discuss] Performance of opensolaris

2009-07-28 Thread Bruno Damour
Anon Y Mous wrote: SXCE and OpenSolaris are both unfinished "works in progress" and the performance changes radically from one build to another. In my particular case, I didn't notice any change between the different builds I installed. The 8.4 postgresql version however is not that old. __

Re: [osol-discuss] Performance of opensolaris

2009-07-28 Thread Bruno Damour
Anon Y Mous wrote: What build of SXCE are you using? What do you see as output from these commands: uname -a cat /etc/release amber ~ # uname -a SunOS amber 5.11 snv_117 i86pc i386 i86xpv amber ~ # cat /etc/release Solaris Express Community Edition snv_117 X86

Re: [osol-discuss] Performance of opensolaris

2009-07-28 Thread Anon Y Mous
What build of SXCE are you using? What do you see as output from these commands: uname -a cat /etc/release SXCE and OpenSolaris are both unfinished "works in progress" and the performance changes radically from one build to another. Read this thread: http://www.opensolaris.org/jive/thr

Re: [osol-discuss] Performance of opensolaris

2009-07-28 Thread Bruno Damour
James Mansion wrote: Bruno Damour wrote: The surprising fact is that the performance is still slightly better on my laptop than on the server. This has been true with postgresql 8.3 and now with postgresql 8.4 as well. ... Is there any explanation you would think of ? If you examine the disk

Re: [osol-discuss] Performance of opensolaris

2009-07-28 Thread James Mansion
Bruno Damour wrote: The surprising fact is that the performance is still slightly better on my laptop than on the server. This has been true with postgresql 8.3 and now with postgresql 8.4 as well. ... Is there any explanation you would think of ? If you examine the disk in device manager on X

[osol-discuss] Performance of opensolaris

2009-07-28 Thread Bruno Damour
Hello, The previous thread reminds me of one surprising fact I've been fundering over for some time. Now I love opensolaris and I have SXCE 64bit installed on my home server (Quad Core E6600, Asus P5W-DH mobo, 8G ram PC6400, SATA disks in AHCI mode). Zfs of course. My work machine is a 2 yea