Re: AWS forcing PG upgrade from v9.6 a disaster

2021-05-29 Thread Jan Wieck
On Fri, May 28, 2021, 22:41 Andrew Dunstan wrote: > > On 5/28/21 10:27 PM, Jan Wieck wrote: > > > > > > On Fri, May 28, 2021, 17:15 Andrew Dunstan > <mailto:and...@dunslane.net>> wrote: > > > > > > > > > > AIUI he did an RDS

Re: AWS forcing PG upgrade from v9.6 a disaster

2021-05-28 Thread Jan Wieck
On Fri, May 28, 2021, 17:15 Andrew Dunstan wrote: > > On 5/28/21 4:23 PM, Jan Wieck wrote: > > On 5/28/21 2:48 PM, Dean Gibson (DB Administrator) wrote: > > > > What sticks out for me are these two scans, which balloon from 50-60 >

Re: AWS forcing PG upgrade from v9.6 a disaster

2021-05-28 Thread Jan Wieck
abase? pg_dump -> psql/pg_restore? If so, did you perform a VACUUM FREEZE after the load? Regards, Jan -- Jan Wieck Postgres User since 1994