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 were a lot of knobs to
> change/fix/modify because of this. However, nothing I did fixed the
> problem. Until... I upgraded the kernel.
We ran head-long into this problem the day after you posted this. We
are in the process of moving from PG 8.4 on UB Server 10.0 LTS onto
PG 9.2 on UB Server 12.04 LTS and encountered this very issue during the
pg_upgradecluster process.
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
kernels for Precise?
Bosco.