From: Jon Schewe <jpschewe@mtu.net>
To: pgsql-performance@postgresql.org
Subject: How filesystems matter with PostgreSQL
Date: Fri, 04 Jun 2010 07:17:35 -0500
Message-ID: <4C08EEDF.7090403@mtu.net> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jpschewe@mtu.net
Subject: Re: How filesystems matter with PostgreSQL
In-Reply-To: <4C08EEDF.7090403@mtu.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox