Re: 9.4 regression - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: 9.4 regression
Date
Msg-id 20130808214618.GC23572@momjian.us
Whole thread Raw
In response to Re: 9.4 regression  (Jon Nelson <jnelson+pgsql@jamponi.net>)
List pgsql-hackers
On Thu, Aug  8, 2013 at 04:33:05PM -0500, Jon Nelson wrote:
> > How much slower would it be if we wrote it with zeros after
> > posix_fallocate() --- that would still give use single extents.  Has
> > anyone tested to see if the write without test_fallocate() still gives
> > us one extent?
> 
> Actually, I did that test - I found that there was no longer a
> performance drop and possibly a slight performance benefit.
> I couldn't quite parse your last sentence, I assume you mean "does
> skipping the posix_fallocate altogether still produce one extent?"
> Sadly, I can't really test that properly as the ext4 filesystem I'm
> testing on is quite fresh and has lots and lots of free space.

Yes, that was the question.  I meant to say:
Has anyone tested to see if the write without posix_fallocate() stillcreates one extent per 16MB file, meaning the
posix_fallocate()isunnecessary?
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.4 regression
Next
From: Jon Nelson
Date:
Subject: Re: 9.4 regression