Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Greg Smith
On Mon, 26 Nov 2007, Damon Hart wrote: Fedora 8: Linux 2.6.23.1-49.fc8 #1 SMP Thu Nov 8 21:41:26 EST 2007 i686 i686 i386 GNU/Linux OpenVZ: Linux 2.6.18-8.1.15.el5.028stab049.1 #1 SMP Thu Nov 8 16:23:12 MSK 2007 i686 i686 i386 GNU/Linux 2.6.23 introduced a whole new scheduler: http://www.linu

Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Damon Hart
On Mon, 2007-11-26 at 18:06 -0500, Tom Lane wrote: > Damon Hart <[EMAIL PROTECTED]> writes: > > So, what's different between these tests? I'm seeing performance > > differences of between +65% to +90% transactions per second of the > > OpenVZ kernel running on the HN over the stock Fedora 8 kernel.

Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Damon Hart
On Mon, 2007-11-26 at 17:00 -0600, Scott Marlowe wrote: > On Nov 26, 2007 4:50 PM, Damon Hart <[EMAIL PROTECTED]> wrote: > > > > So, what's different between these tests? I'm seeing performance > > differences of between +65% to +90% transactions per second of the > > OpenVZ kernel running on the H

Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Scott Marlowe
On Nov 26, 2007 5:00 PM, Alexander Staubo <[EMAIL PROTECTED]> wrote: > On 11/26/07, Damon Hart <[EMAIL PROTECTED]> wrote: > > So, what's different between these tests? I'm seeing performance > > differences of between +65% to +90% transactions per second of the > > OpenVZ kernel running on the HN o

Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Tom Lane
Damon Hart <[EMAIL PROTECTED]> writes: > So, what's different between these tests? I'm seeing performance > differences of between +65% to +90% transactions per second of the > OpenVZ kernel running on the HN over the stock Fedora 8 kernel. Is > this reflective of different emphasis between RHEL an

Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Scott Marlowe
On Nov 26, 2007 4:50 PM, Damon Hart <[EMAIL PROTECTED]> wrote: > > So, what's different between these tests? I'm seeing performance > differences of between +65% to +90% transactions per second of the > OpenVZ kernel running on the HN over the stock Fedora 8 kernel. Is > this reflective of differen

Re: [PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Alexander Staubo
On 11/26/07, Damon Hart <[EMAIL PROTECTED]> wrote: > So, what's different between these tests? I'm seeing performance > differences of between +65% to +90% transactions per second of the > OpenVZ kernel running on the HN over the stock Fedora 8 kernel. Is > this reflective of different emphasis bet

[PERFORM] PostgreSQL performance on various distribution stock kernels

2007-11-26 Thread Damon Hart
Is there a source comparing PostgreSQL performance (say, using pgbench) out of the box for various Linux distributions? Alternately, is there an analysis anywhere of the potential gains from building a custom kernel and just what customizations are most relevant to a PostgreSQL server? Some backg