Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.4 to 9.2 migration performance - Mailing list pgsql-performance

From bricklen
Subject Re: 8.4 to 9.2 migration performance
Date
Msg-id CAGrpgQ-UG4JiYxNKe4ZPhE8_V=WFG-D8SR0Qa9M3s68BN5ovkg@mail.gmail.com
Whole thread Raw
In response to 8.4 to 9.2 migration performance  (Tom Harkaway <tomh@hvpa.com>)
List pgsql-performance
Tree view
On Mon, Jul 8, 2013 at 9:21 AM, Tom Harkaway <tomh@hvpa.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

pgsql-performance by date:

Previous
From: Jeison Bedoya
Date:
Subject: Process in state BIND, authentication, PARSE
Next
From: Andrew Dunstan
Date:
Subject: Re: Process in state BIND, authentication, PARSE