Performance Difference on UFS and ZFS

[Sergey Kandaurov]

On 28 November 2012 12:35, Metin Döşlü <metindoslu at 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öşlü!

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.

-- 
wbr,
pluknet