Re: Query-Planer from 6seconds TO DAYS

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Böckler Andreas <andy(at)boeckler(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query-Planer from 6seconds TO DAYS
Date: 2012-10-26 18:00:55
Message-ID: CAMkU=1yaCmh9HXVB++vESGeHSHj62LZjHcwSu5bgrCn1MAUVXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Oct 26, 2012 at 8:30 AM, Böckler Andreas <andy(at)boeckler(dot)org> wrote:
>
> Am 25.10.2012 um 18:20 schrieb Jeff Janes:
>
>> Can you load the data into 9.2 and see if it does better? (I'm not
>> optimistic that it will be.)
>
> This takes months, the customer has to pay us for that ;)

You probably only need to load one partition to figure out if does a
better job there.

Once you know if it solves the problem, then you can make an informed
decision on whether migration might be worthwhile.

Cheers,

Jeff

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message robcron 2012-10-26 18:30:00 Slower Performance on Postgres 9.1.6 vs 8.2.11
Previous Message Shaun Thomas 2012-10-26 17:58:57 PSA: New Kernels and intel_idle cpuidle Driver!