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 only look on following blogs:
http://blogs.sun.com/jkshah/category/PostgreSQL http://blogs.sun.com/paulvandenbogaard/category/PostgreSQL http://www.solarisinternals.com/wiki/index.php/ZFS_Evil_Tuning_Guide Please let me know if something help you. Zdenek Bruno Damour píše v st 29. 07. 2009 v 06:10 +0200: > 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 year old Dell laptop (Core 2, 1G ram), running > WindowsXP. > > I use postgresql quite a lot (though rather small databases), and I have > a backup on the server. > > 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. > I find this quite surprising as both hardware and OS (64bit) seem to be > a lot better on the server. > Furthermore, I had to tweak postgresql a bit to even get on the same > level of performance than the default windows setup. > > Is there any explanation you would think of ? > > Bruno > _______________________________________________ > opensolaris-discuss mailing list > opensolaris-discuss@opensolaris.org _______________________________________________ opensolaris-discuss mailing list opensolaris-discuss@opensolaris.org
