Date: Sat, 17 Dec 2011 08:59:40 -0600 From: Adam Vande More <amvandemore@gmail.com> To: Martin Matuska <mm@freebsd.org> Cc: freebsd-performance@freebsd.org Subject: Re: PostgreSQL user experience: FreeBSD (ZFS) vs OpenIndiana (ZFS) vs Linux (EXT4) Message-ID: <CA%2BtpaK3n0RJvuqP5c_A0ekgFqiGa%2Bn1LZ8fo3sNxP2Tbsno%2Bzw@mail.gmail.com> In-Reply-To: <4EEC9890.7040806@FreeBSD.org> References: <4EEC9890.7040806@FreeBSD.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sat, Dec 17, 2011 at 7:26 AM, Martin Matuska <mm@freebsd.org> wrote: > I would like to share some of our expreience with PostgreSQL on FreeBSD. > It has been a while ago since we had to stop using FreeBSD for our > customer's PostgreSQL servers. > I don't claim any expertise in this area so please take this with that in mind. A couple of things that might help. Setting zfs set sync=disabled on fs where the WAL resides(all alone). Of course this would help ZFS regardless of OS. http://www.postgresql.org/docs/8.4/static/wal-intro.html I've also seen other reports of slow PostgreSQL on FreeBSD, and in that scenario there were a large amount of gettimeofday(2) calls as the bottleneck and such calls on FreeBSD are significantly slower. http://postgresql.1045698.n5.nabble.com/Postgresql-9-0-2-explain-analyze-very-slow-10x-compared-to-actual-query-time-td3336664.html If you have a faster timecounter, it might help to switch. -- Adam Vande More
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CA%2BtpaK3n0RJvuqP5c_A0ekgFqiGa%2Bn1LZ8fo3sNxP2Tbsno%2Bzw>