Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-20 Thread Shaun Thomas
On 06/17/2013 04:00 PM, Joshua D. Drake wrote: http://postgresql.1045698.n5.nabble.com/Ubuntu-12-04-3-2-Kernel-Bad-for-PostgreSQL-Performance-td5735284.html tl;dr for that thread seems to be a driver problem (fusionIO?), I'm unsure if Ubuntu specific or in the upstream kernel. That instance

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-20 Thread Scott Marlowe
Good to know. I've got a few spare machines I might be able to test 3.2 kernels on in the next few months On Thu, Jun 20, 2013 at 12:54 PM, Shaun Thomas stho...@optionshouse.com wrote: On 06/17/2013 04:00 PM, Joshua D. Drake wrote:

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-17 Thread Stuart Bishop
On Fri, Jun 7, 2013 at 5:51 AM, Joshua D. Drake j...@commandprompt.com wrote: On 06/06/2013 03:48 PM, Scott Marlowe wrote: On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake j...@commandprompt.com wrote: I had the distinct displeasure of staying up entirely too late with a customer this week

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-17 Thread Joshua D. Drake
On 06/17/2013 01:34 PM, Stuart Bishop wrote: I've since heard that 3.4 also fixes this issue as well. What are you using for your IO on these boxes? I was able to demonstrate it over iSCSI to a Nimble Storage SAN as well as DAS with 2 drive RAID 1 for xlogs and 8 drive RAID 10 for data

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-14 Thread Bosco Rama
On 06/06/13 15:35, Joshua D. Drake wrote: I had the distinct displeasure of staying up entirely too late with a customer this week because they upgraded to 12.04 and immediately experienced a huge performance regression. In the process they also upgraded to PostgreSQL 9.1 from 8.4. There

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-14 Thread Joshua D. Drake
On 06/14/2013 09:12 AM, Bosco Rama wrote: A colleague mentioned this LKML thread: http://lkml.indiana.edu/hypermail/linux/kernel/1210.1/00725.html Seems it was fixed in 3.9.x. I'm wonder if there is any way to easily determine if the fix was back-ported to the various Ubunutu-maintained

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-11 Thread Toby Corkindale
Perhaps someone with a spare server floating around could install Ubuntu LTS and run some pg-bench benchmarks with the various kernel options? Like you, I'd have to stick to official updates for production systems. -Toby On 07/06/13 15:36, Nikhil G Daddikar wrote: Folks, This is bad news as

[GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-06 Thread Joshua D. Drake
Hello, I had the distinct displeasure of staying up entirely too late with a customer this week because they upgraded to 12.04 and immediately experienced a huge performance regression. In the process they also upgraded to PostgreSQL 9.1 from 8.4. There were a lot of knobs to

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-06 Thread Scott Marlowe
On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake j...@commandprompt.com wrote: Hello, I had the distinct displeasure of staying up entirely too late with a customer this week because they upgraded to 12.04 and immediately experienced a huge performance regression. In the process they also

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-06 Thread Joshua D. Drake
On 06/06/2013 03:48 PM, Scott Marlowe wrote: On Thu, Jun 6, 2013 at 4:35 PM, Joshua D. Drake j...@commandprompt.com wrote: Hello, I had the distinct displeasure of staying up entirely too late with a customer this week because they upgraded to 12.04 and immediately experienced a huge

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-06 Thread Toby Corkindale
On 07/06/13 08:35, Joshua D. Drake wrote: Hello, I had the distinct displeasure of staying up entirely too late with a customer this week because they upgraded to 12.04 and immediately experienced a huge performance regression. In the process they also upgraded to PostgreSQL 9.1 from 8.4.

Re: [GENERAL] PSA: If you are running Precise/12.04 upgrade your kernel.

2013-06-06 Thread Nikhil G Daddikar
Folks, This is bad news as I run Ubuntu 12.04 LTS. However, my ubuntu 12.04 LTS boxes have been updated to 3.5.0-32-generic (official update). Any idea whether the Postgresql has problems with this kernel? I'd like to follow the official LTS updates because I am not sure what other surprises