Re: dump time increase by 1h with new kernel

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
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-04 05:31:11
Message-ID: dcc563d10910032231q55c01eebwfb7d0117b0c2e0db@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Oct 2, 2009 at 7:48 PM, Justin Pryzby <justinp(at)norchemlab(dot)com> wrote:
> [I got no response on -general for a few days so I'm trying here]
>
> 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.  My first attempt at
> resolution was to boot with elevator=deadline.  However that's
> actually the default IO scheduler in both kernels.

To add to what tom said, when you post this to something like kernel
hackers, it would really help if you could test the two other kernels
between these two to tell them exactly which one(s) causes the
regression(s). That and how you compiled them or where they came from
otherwise (fc, Ubuntu dev, yada)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-10-04 11:06:54 Re: [PERFORM] Postgres performance
Previous Message Tom Lane 2009-10-04 02:53:04 Re: Performance problems with DISTINCT ON