Skip site navigation (1) Skip section navigation (2)

Re: Mount options for Ext3?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql(at)vinz(dot)nl
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Mount options for Ext3?
Date: 2003-01-26 05:34:48
Message-ID: 26592.1043559288@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
pgsql(dot)spam(at)vinz(dot)nl writes:
> If one were certain his OS wouldn't do any re-ordering of writes, would it be
> safe to run with fsync = off? (not that I'm going to try this, but I'm just
> curious)

I suppose so ... but if your OS doesn't do *any* re-ordering of writes,
I'd say you need a better OS.  Even in Postgres, we'd often like the OS
to collapse multiple writes of the same disk page into one write.  And
we certainly want the various writes forced by a sync() to be done with
some intelligence about disk layout, not blindly in order of issuance.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Ron JohnsonDate: 2003-01-26 08:04:45
Subject: Re: Mount options for Ext3?
Previous:From: Tom LaneDate: 2003-01-26 05:27:51
Subject: Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-01-26 05:37:53
Subject: Re: Can we revisit the thought of PostgreSQL 7.2.4?
Previous:From: Tom LaneDate: 2003-01-26 05:27:51
Subject: Re: [PERFORM] Proposal: relaxing link between explicit JOINs and execution order

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group