pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: mark@mark.mielke.cc
Cc: Jim C. Nasby <jnasby@pervasive.com>
Cc: Steve Poe <steve.poe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql Performance on an HP DL385 and
Date: Tue, 15 Aug 2006 16:40:09 -0400
Message-ID: <20113.1155674409@sss.pgh.pa.us> (raw)
In-Reply-To: <20060815202948.GC13695@mark.mielke.cc>
References: <20060809210539.GR40481@pervasive.com>
	<1155180553.13315.0.camel@amd64-gentoo-laptop>
	<20060810110935.GF2900@mathom.us>
	<20060814153841.GF27928@pervasive.com>
	<721b21dc0608140851v2332cdf9g59808004c983540f@mail.gmail.com>
	<20060814170545.GG27928@pervasive.com>
	<20060814170902.GN2900@mathom.us>
	<20060815162926.GS27928@pervasive.com>
	<20060815183147.GB12834@mark.mielke.cc>
	<19783.1155672317@sss.pgh.pa.us>
	<20060815202948.GC13695@mark.mielke.cc>

mark@mark.mielke.cc writes:
> WAL file is never appended - only re-written?

> If so, then I'm wrong, and ext2 is fine. The requirement is that no
> file system structures change as a result of any writes that
> PostgreSQL does. If no file system structures change, then I take
> everything back as uninformed.

That risk certainly exists in the general data directory, but AFAIK
it's not a problem for pg_xlog.

			regards, tom lane



view thread (70+ messages)  latest in thread

Message-ID: <20113.1155674409@sss.pgh.pa.us>
Permalink:  ../20113.1155674409@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/20113.1155674409@sss.pgh.pa.us

 · 

reply
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: tgl@sss.pgh.pa.us, mark@mark.mielke.cc, jnasby@pervasive.com, steve.poe@gmail.com
  Subject: Re: Postgresql Performance on an HP DL385 and
  In-Reply-To: <20113.1155674409@sss.pgh.pa.us>

* 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