AW: Re: New Linux xfs/reiser file systems - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Re: New Linux xfs/reiser file systems
Date
Msg-id 11C1E6749A55D411A9670001FA6879633682B4@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
> > I don't have a machine with XFS installed and it will be at least a week
> > before I could get around to a build.  Any volunteers?
> 
> I think I could do that... any useful benchmarks to run?

Looks like we have expert help here :-) One very interesting question
would imho be, how do we best preallocate the log files ?
The current method is to prewrite 8k pages to the whole file, since
only writing 1 byte to the end of file triggered the sparse file handling.
This, although usually during off peak times, effectively doubles the writes 
for WAL. 

Andreas


pgsql-hackers by date:

Previous
From: bruc@stone.congenomics.com (Robert E. Bruccoleri)
Date:
Subject: Re: XFS File systems and PostgreSQL
Next
From: Jan Wieck
Date:
Subject: Re: \c connects as another user instead I want in psql