How filesystems matter with PostgreSQL

From: Jon Schewe <jpschewe(at)mtu(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: How filesystems matter with PostgreSQL
Date: 2010-06-04 12:17:35
Message-ID: 4C08EEDF.7090403@mtu.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Some interesting data about different filesystems I tried with
PostgreSQL and how it came out.

I have an application that is backed in postgres using Java JDBC to
access it. The tests were all done on an opensuse 11.2 64-bit machine,
on the same hard drive (just ran mkfs between each test) on the same
input with the same code base. All filesystems were created with the
default options.

XFS (logbufs=8): ~4 hours to finish
ext4: ~1 hour 50 minutes to finish
ext3: 15 minutes to finish
ext3 on LVM: 15 minutes to finish

--
Jon Schewe | http://mtu.net/~jpschewe
If you see an attachment named signature.asc, this is my digital
signature. See http://www.gnupg.org for more information.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message J. Roeleveld 2010-06-04 12:39:15 Re: How filesystems matter with PostgreSQL
Previous Message Matthew Wakeling 2010-06-04 09:27:04 Re: Weird XFS WAL problem