Re: [HACKERS] Performance while loading data and indexing - Mailing list pgsql-general

From Neil Conway
Subject Re: [HACKERS] Performance while loading data and indexing
Date
Msg-id 871y7g1o1e.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: Performance while loading data and indexing  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [HACKERS] Performance while loading data and indexing
Re: [HACKERS] Performance while loading data and indexing
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> The paper does recommend ext3, but the differences between file systems
> are very small.

Well, I only did a very rough benchmark (a few runs of pgbench), but
the results I found were drastically different: ext2 was significantly
faster (~50%) than ext3-writeback, which was in turn significantly
faster (~25%) than ext3-ordered.

> Also, though ext3 is slower, turning fsync off should make ext3 function
> similar to ext2.

Why would that be?

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Performance while loading data and indexing