Issues on 9.5 to 9.6 Upgrade.

Servers: Redhack 6.9 64 bit.Postgres OLD Server version 9.5.6Postgres New Server 9.6.6Issues BIG difference in speed on the following SQL statement from 9.5 to 9.6 ...EXPLAIN ANALYZEselect de_caseid, de_seqno, de_document_num, doc_link.dm_id as dm_id,   doc_link.dm_seq as dm_seq, doc_link.dm_dls_id

RE: Issues on 9.5 to 9.6 Upgrade.

Analyze the DB exactly how?I did run a reindexdb after migration to no affect.Yeah the PLANS are a big difference Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212"Never attribute to malice, that which can be adequately explained by stupidity"- Hanlon's Razor ---

RE: Issues on 9.5 to 9.6 Upgrade.

Ok, this seemed to solve it:> vacuumdb -zv ; reindexdb -vAnd we are back to full speed Thanks for pointing out the ANALYZE ...Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212"Never attribute to malice, that which can be adequately explained by stupidity"- Hanlon's

RE: Trouble Upgrading Postgres

As someone pointed out, there is a limit with bytea (Blob's).To test if it is bytea, use a COPY with a select statement :COPY ( select A, B,C ,D ...etc FROM table ) TO 'outfile' ;Leaveing out the bytea column.If this works, then then one of the bytea columns is way to big.Ben Duncan - Business Netw