<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Analyze the DB exactly how?</div><div><br></div><div>I did run a reindexdb after migration to no affect.</div><div><br></div><div>Yeah the PLANS are a big difference ....<br></div><div><br></div><div><span style="font-size: 8pt;"></span><span style="font-size: 8pt;">Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212<br>"Never attribute to malice, that which can be adequately explained by stupidity"<br>- Hanlon's Razor<br></span></div><div><br><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: Issues on 9.5 to 9.6 Upgrade.<br>
From: Don Seiler <<a href="mailto:don(at)seiler(dot)us">don(at)seiler(dot)us</a>><br>
Date: Wed, June 13, 2018 11:24 am<br>
To: <a href="mailto:bend(at)linux4ms(dot)net">bend(at)linux4ms(dot)net</a><br>
Cc: Postgres General <<a href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>><br>
<br>
<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, Jun 13, 2018 at 11:16 AM, <span dir="ltr"><<a href="mailto:bend(at)linux4ms(dot)net" target="_blank">bend(at)linux4ms(dot)net</a>></span> wrote:<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><span style="font-family:Verdana;color:#000000;font-size:10pt"><div><br></div><div>Can anyoen explain WHY there is such a big difference? Is it the SQL statement or a bug in the pgdump ?<br></div><div><br></div></span></div> </blockquote></div><br>Did you analyze the database after upgrading? Or at least the tables in question? Those are very different plans.<br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Don Seiler<br><a href="http://www.seiler.us" target="_blank">www.seiler.us</a></div></div></div> </div></div>
</div>
</blockquote></span></body></html>