Date: Wed, 28 Nov 2012 17:49:12 +0300 From: Sergey Kandaurov <pluknet@gmail.com> To: =?UTF-8?B?TWV0aW4gRMO2xZ9sw7w=?= <metindoslu@gmail.com> Cc: freebsd-fs@freebsd.org Subject: Re: Performance Difference on UFS and ZFS Message-ID: <CAE-mSOLcc-USkCZqsiCFsp2SqJ7VPDdkkCHRCxP=8hSg=gAjdw@mail.gmail.com> In-Reply-To: <CAJOrxZCNeo-v_=LT8x1UniRspzZ5qs_DnnOtnb4DnF-RwGFJFw@mail.gmail.com> References: <CAJOrxZCNeo-v_=LT8x1UniRspzZ5qs_DnnOtnb4DnF-RwGFJFw@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 28 November 2012 12:35, Metin D=C3=B6=C5=9Fl=C3=BC <metindoslu@gmail.com= > wrote: > Hi - > > I installed PostgreSQL 9.1.6 on FreeBSD 9.0-RELEASE, and compared ZFS > to UFS. I also made sure all data easily fit into memory, ran some > sequential scan queries on the database. > > Query run times on UFS were 100-200% slower than those of ZFS. This > was intriguing as all data came from memory. What could be causing > such a large performance difference? Hi Metin D=C3=B6=C5=9Fl=C3=BC! That's interesting. Can you please share your settings? Hardware configuration, system tuning (sysctl, zfs), PostgreSQL settings, data access pattern (read/write ratio), and how you measure performance would be a good start. --=20 wbr, pluknet
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAE-mSOLcc-USkCZqsiCFsp2SqJ7VPDdkkCHRCxP=8hSg=gAjdw>