Re: dump time increase by 1h with new kernel

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Pryzby <justinp(at)norchemlab(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: dump time increase by 1h with new kernel
Date: 2009-10-03 02:35:41
Message-ID: 20957.1254537341@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Justin Pryzby <justinp(at)norchemlab(dot)com> writes:
> When we upgraded from linux-2.6.24 to linux-2.6.27, our pg_dump
> duration increased by 20% from 5 hours to 6.

Wouldn't be the first time the kernel guys broke something :-(
I think a complaint to your kernel supplier is in order.

In a coincidence, the first item in the changelog for this week's
Fedora kernel update is:

* Fri Sep 25 2009 Chuck Ebbert <cebbert(at)redhat(dot)com> 2.6.30.8-64
- Fix serious CFQ performance regression.

This is surely not the exact same issue you are seeing, but it does
illustrate that performance regressions in the kernel aren't
unheard-of.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message S Arvind 2009-10-03 06:11:41 Re: Confusion on shared buffer
Previous Message Justin Pryzby 2009-10-03 01:48:08 dump time increase by 1h with new kernel