On Nov 5, 2010, at 1:19 PM, Josh Berkus wrote:
>
>> The serious problems with this appear to be (a) that Linux/Ext4 PG
>> performance still hasn't fully recovered, and, (b) that RHEL6 is set to
>> ship with kernel 2.6.32, which means that we'll have a whole generation
>> of RHEL which is off-lim
> The main change here was discussed back in January:
> http://archives.postgresql.org/message-id/4b512d0d.4030...@2ndquadrant.com
>
> What I've been doing about this is the writing leading up to
> http://wiki.postgresql.org/wiki/Reliable_Writes so that when RHEL6 does
> ship, we have a place to
Josh Berkus wrote:
Domas (of Facebook/Wikipedia, MySQL geek) pointed me to this report:
http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&num=1
http://www.phoronix.com/scan.php?page=article&item=ext4_then_now&num=6
The main change here was discussed back in January:
On Fri, Nov 5, 2010 at 2:32 PM, Josh Berkus wrote:
>
>> Why would it be off limits? Is it likely to lose data due to power failure
>> etc?
>
> If fsyncs are taking 5X as long, people can't use PostgreSQL on that
> platform.
I was under the impression that from 2.6.28 through 2.6.31 or so that
t
On Friday 05 November 2010 21:15:20 Josh Berkus wrote:
> All,
>
> Domas (of Facebook/Wikipedia, MySQL geek) pointed me to this report:
>
> http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&n
I guess thats the O_DSYNC thingy. See the "Defaulting wal_sync_method to
fdatasy
> Why would it be off limits? Is it likely to lose data due to power failure
> etc?
If fsyncs are taking 5X as long, people can't use PostgreSQL on that
platform.
> Are you referring to improvements due to write barrier support getting
> fixed up fr ext4 to run faster but still be safe? I wou
On Fri, Nov 5, 2010 at 2:15 PM, Josh Berkus wrote:
> All,
>
> Domas (of Facebook/Wikipedia, MySQL geek) pointed me to this report:
>
> http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&num=1
> http://www.phoronix.com/scan.php?page=article&item=ext4_then_now&num=6
>
> The se
> The serious problems with this appear to be (a) that Linux/Ext4 PG
> performance still hasn't fully recovered, and, (b) that RHEL6 is set to
> ship with kernel 2.6.32, which means that we'll have a whole generation
> of RHEL which is off-limits to PostgreSQL.
Oh. Found some other information o
All,
Domas (of Facebook/Wikipedia, MySQL geek) pointed me to this report:
http://www.phoronix.com/scan.php?page=article&item=linux_perf_regressions&num=1
http://www.phoronix.com/scan.php?page=article&item=ext4_then_now&num=6
The serious problems with this appear to be (a) that Linux/Ext4 PG
perf