Re: Query-Planer from 6seconds TO DAYS

From: Böckler Andreas <andy(at)boeckler(dot)org>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query-Planer from 6seconds TO DAYS
Date: 2012-10-26 15:30:47
Message-ID: 7161394C-B48E-4568-AF2D-FAEFC51D1BF3@boeckler.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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 ;)
There are already talks about moving it to a new server, but this is for next year.

And it will be no child's play to migrate about 1.6TB of data from 8.4 to 9.2.

Cheers,

Andy
--
Andreas Böckler
andy(at)boeckler(dot)org

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ktm@rice.edu 2012-10-26 15:30:49 Re: Query-Planer from 6seconds TO DAYS
Previous Message Alberto Marchesini 2012-10-26 15:30:23 BAD performance with enable_bitmapscan = on with Postgresql 9.0.X (X = 3 and 10)