Re: Poor performance of btrfs with Postgresql - Mailing list pgsql-general

From Andres Freund
Subject Re: Poor performance of btrfs with Postgresql
Date
Msg-id 201104211503.59149.andres@anarazel.de
Whole thread Raw
In response to Re: Poor performance of btrfs with Postgresql  ("Henry C." <henka@cityweb.co.za>)
List pgsql-general
On Thursday, April 21, 2011 12:16:04 PM Henry C. wrote:
> > I've done some testing of PostgreSQL on different filesystems, and with
> > different filesystem mount options.
>
> Since Pg is already "journalling", why bother duplicating (and pay the
> performance penalty, whatever that penalty may be) the effort for no real
> gain (except maybe a redundant sense of safety)?  ie, use a
> non-journalling battle-tested fs like ext2.
Don't. The fsck on reboot will eat way too much time.

Using metadata only journaling is ok though. In my opinion the problem with
btrfs is more the overhead of COW, but thats an impression from several kernel
version ago, so...

Andres

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [HACKERS] Defining input function for new datatype
Next
From: Tiruvenkatasamy Baskaran
Date:
Subject: Re: Which version of postgresql supports replication on RHEL6?