<html><body><span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Ok, this seemed to solve it:</div><div><br></div><div>> vacuumdb -zv ; reindexdb -v<br></div><div><br></div><div>And we are back to full speed ....</div><div><br></div><div>Thanks for pointing out the ANALYZE ...</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: Adrian Klaver <<a href="mailto:adrian(dot)klaver(at)aklaver(dot)com">adrian(dot)klaver(at)aklaver(dot)com</a>><br>
Date: Wed, June 13, 2018 11:45 am<br>
To: <a href="mailto:bend(at)linux4ms(dot)net">bend(at)linux4ms(dot)net</a>, Postgres General <<a href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>><br>
<br>
On 06/13/2018 09:44 AM, <a href="mailto:bend(at)linux4ms(dot)net">bend(at)linux4ms(dot)net</a> wrote:<br>
> Analyze the DB exactly how?<br>
<br>
<a href="https://www.postgresql.org/docs/10/static/sql-analyze.html">https://www.postgresql.org/docs/10/static/sql-analyze.html</a><br>
<br>
> <br>
> I did run a reindexdb after migration to no affect.<br>
> <br>
> Yeah the PLANS are a big difference ....<br>
> <br>
> Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, <br>
> 39212<br>
> "Never attribute to malice, that which can be adequately explained by <br>
> stupidity"<br>
> - Hanlon's Razor<br>
> <br>
> <br>
> -------- 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> ><<a href="mailto:don(at)seiler(dot)us">mailto: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> <<a href="mailto:bend(at)linux4ms(dot)net">mailto: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>
> <<a href="mailto:pgsql-general(at)postgresql(dot)org">mailto:pgsql-general(at)postgresql(dot)org</a>>><br>
> <br>
> On Wed, Jun 13, 2018 at 11:16 AM, <<a href="mailto:bend(at)linux4ms(dot)net">bend(at)linux4ms(dot)net</a><br>
> <<a href="mailto:bend(at)linux4ms(dot)net">mailto:bend(at)linux4ms(dot)net</a>>> wrote:<br>
> <br>
> <br>
> Can anyoen explain WHY there is such a big difference? Is it the<br>
> SQL statement or a bug in the pgdump ?<br>
> <br>
> <br>
> Did you analyze the database after upgrading? Or at least the tables<br>
> in question? Those are very different plans.<br>
> <br>
> -- <br>
> Don Seiler<br>
> <a href="http://www.seiler.us">www.seiler.us</a> <http://<a href="http://www.seiler.us">www.seiler.us</a>><br>
> <br>
<br>
<br>
-- <br>
Adrian Klaver<br>
<a href="mailto:adrian(dot)klaver(at)aklaver(dot)com">adrian(dot)klaver(at)aklaver(dot)com</a><br>
<br>
</div>
</blockquote></span></body></html>