[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] 8.4 to 9.2 migration performance
From:       bricklen <bricklen () gmail ! com>
Date:       2013-07-08 16:31:39
Message-ID: CAGrpgQ-UG4JiYxNKe4ZPhE8_V=WFG-D8SR0Qa9M3s68BN5ovkg () mail ! gmail ! com
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Mon, Jul 8, 2013 \
at 9:21 AM, Tom Harkaway <span dir="ltr">&lt;<a href="mailto:tomh@hvpa.com" \
target="_blank">tomh@hvpa.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">






<div link="blue" vlink="purple" lang="EN-US">
<div>The ‘explain' output for the query is very different between the two systems.

</div></div></blockquote></div><br></div><div class="gmail_extra">You ran ANALYZE \
after loading the data?   Can you post the query and EXPLAIN ANALYZE output?<br>Also, \
some tips on getting answers with (potentially) less ping pong discussion can be \
found here: <a href="https://wiki.postgresql.org/wiki/Slow_Query_Questions">https://wiki.postgresql.org/wiki/Slow_Query_Questions</a><br>
 </div></div>



[prev in list] [next in list] [prev in thread] [next in thread]