Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-11 Thread Cyril Scetbon
Greg Smith a écrit : Rodger Donaldson wrote: Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 http://www.csamuel

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-09 Thread Rodger Donaldson
On Tue, Mar 09, 2010 at 11:58:58AM -0500, Greg Smith wrote: > Rodger Donaldson wrote: > >Cyril Scetbon wrote: > >>Does anyone know what can be the differences between linux kernels > >>2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) > >>http://www.phoronix.com/scan.php?page=article

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-09 Thread Greg Smith
Rodger Donaldson wrote: Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 http://www.csamuel.org/2009/04/11/default-ex

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-09 Thread Rodger Donaldson
Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 http://www.csamuel.org/2009/04/11/default-ext3-mode-changing-in-2630

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-08 Thread John R Pierce
Albe Laurenz wrote: "the PostgreSQL performance atop the EXT3 file-system has fallen off a cliff" really a pretty stupid statement from them, as the performance went right back to where it was a few versions earlier. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-08 Thread Greg Smith
Albe Laurenz wrote: Maybe that question is dumb, but why should a change in ext4 have an impact on a figure that was generated with ext3? To quote the link: "the PostgreSQL performance atop the EXT3 file-system has fallen off a cliff" What I'm guessing is that after finding the root problem

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-08 Thread Albe Laurenz
Greg Smith wrote: > Cyril Scetbon wrote: > > Does anyone know what can be the differences between linux kernels > > 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) > > > http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 > > Discussed in detail at > http:/

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-05 Thread Greg Smith
Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 Discussed in detail at http://archives.postgresql.org/message-id/4b

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-05 Thread John R Pierce
Scott Marlowe wrote: On Fri, Mar 5, 2010 at 7:09 AM, Cyril Scetbon wrote: Does anyone know what can be the differences between linux kernels 2.6.29 and 2.6.30 that can cause this big difference (TPS x 7 !) http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 I'm go

Re: [GENERAL] kernel version impact on PostgreSQL performance

2010-03-05 Thread Scott Marlowe
On Fri, Mar 5, 2010 at 7:09 AM, Cyril Scetbon wrote: > Does anyone know what can be the differences between linux kernels 2.6.29 > and 2.6.30 that can cause this big difference (TPS x 7 !) > http://www.phoronix.com/scan.php?page=article&item=linux_2624_2633&num=2 I'm gonna guess those ones with h