On 5/28/21 5:38 PM, Dean Gibson (DB Administrator) wrote:
>>
>> Did it run in less than 10 hours?
>>
>
> The original VACUUM FULL ANALYZE ran in 10 hours. The plain ANALYZE ran
> in 88 seconds.
Can you repeat your EXPLAIN (ANALYZE, BUFFERS) of the query from your
first post and post them here:
https://explain.depesz.com/
Other information:
1) A diff of your configuration settings between 9.6 and 13.2.
2) Are you running on the same AWS instance type for the two versions of
Postgres?
It is not necessary to repeat the table/view definitions as they are
available in the first post.
--
Adrian Klaver
adrian.klaver@aklaver.com