Re: 8.4 to 9.2 migration performance

From: bricklen <bricklen(at)gmail(dot)com>
To: Tom Harkaway <tomh(at)hvpa(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 8.4 to 9.2 migration performance
Date: 2013-07-08 16:31:39
Message-ID: CAGrpgQ-UG4JiYxNKe4ZPhE8_V=WFG-D8SR0Qa9M3s68BN5ovkg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jul 8, 2013 at 9:21 AM, Tom Harkaway <tomh(at)hvpa(dot)com> wrote:

> The ‘explain’ output for the query is very different between the two
> systems.
>

You ran ANALYZE after loading the data? Can you post the query and EXPLAIN
ANALYZE output?
Also, some tips on getting answers with (potentially) less ping pong
discussion can be found here:
https://wiki.postgresql.org/wiki/Slow_Query_Questions

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Dunstan 2013-07-08 16:40:03 Re: Process in state BIND, authentication, PARSE
Previous Message Jeison Bedoya 2013-07-08 16:22:12 Process in state BIND, authentication, PARSE