Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-06 Thread John Lister
On 05/12/2012 18:28, Shaun Thomas wrote: Hey guys, This isn't a question, but a kind of summary over a ton of investigation I've been doing since a recent "upgrade". Anyone else out there with "big iron" might want to confirm this, but it seems pretty reproducible. This seems to affect the lates

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Stuart Bishop
On Thu, Dec 6, 2012 at 1:28 AM, Shaun Thomas wrote: > This isn't a question, but a kind of summary over a ton of investigation > I've been doing since a recent "upgrade". Anyone else out there with > "big iron" might want to confirm this, but it seems pretty reproducible. > This seems to affect t

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Scott Marlowe
On Wed, Dec 5, 2012 at 4:04 PM, Shaun Thomas wrote: > On 12/05/2012 04:41 PM, Bruce Momjian wrote: > >> Ah, that is interesting about 2.6. I had wondered how Debian stable >> would have performed, 2.6.32-5. This relates to a recent discussion >> about the appropriateness of Ubuntu for database s

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Shaun Thomas
On 12/05/2012 04:41 PM, Bruce Momjian wrote: Ah, that is interesting about 2.6. I had wondered how Debian stable would have performed, 2.6.32-5. This relates to a recent discussion about the appropriateness of Ubuntu for database servers: Hmm. I may have to recant. I just removed our fusionI

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Bruce Momjian
On Wed, Dec 5, 2012 at 04:25:28PM -0600, Shaun Thomas wrote: > On 12/05/2012 04:19 PM, Daniel Farina wrote: > > >Is 3.2 a significant regression from previous releases, or is 3.4 just > >faster? Your wording only indicates that "older kernel is slow," but > >your tone would suggest that you feel

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Shaun Thomas
On 12/05/2012 04:19 PM, Daniel Farina wrote: Is 3.2 a significant regression from previous releases, or is 3.4 just faster? Your wording only indicates that "older kernel is slow," but your tone would suggest that you feel this is a regression, cf. It's definitely a regression. I'm trying to

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Daniel Farina
On Wed, Dec 5, 2012 at 10:28 AM, Shaun Thomas wrote: > Hey guys, > > This isn't a question, but a kind of summary over a ton of investigation > I've been doing since a recent "upgrade". Anyone else out there with > "big iron" might want to confirm this, but it seems pretty reproducible. > This see

Re: [PERFORM] Ubuntu 12.04 / 3.2 Kernel Bad for PostgreSQL Performance

2012-12-05 Thread Niels Kristian Schjødt
Where as I can't say I yet tried out the 3.4 kernel, I can say that I am running 3.2 too, and maybe there is a connection to the past issues of strange CPU behavior I have had (as you know and have been so kind to try helping me solve). I will without a doubt try out 3.4 or 3.6 within the coming