Subject: Re: AWS forcing PG upgrade from v9.6 a disaster
To: "Dean Gibson (DB Administrator)" <postgresql@mailpen.com>,
 pgsql-general@lists.postgresql.org
References: <3fa6fd38-1f92-98ab-0055-3e0eb7e4e772@ultimeth.com>
 <2a1b34f4-73d4-585b-f4fc-3bd9b9ba248e@aklaver.com>
 <88255b75-e7e3-b29c-0e75-f989ea320570@mailpen.com>
 <70edb767-6ba0-1065-2f74-f01440e3caea@gmail.com>
 <d73e2731-31ba-df14-9b9c-974342200ae8@mailpen.com>
 <2b7b9a25-e3c7-b980-a1e3-d21d8d91d34d@gmail.com>
 <988e2438-c322-c1d5-ca88-683943a80087@mailpen.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com>
Date: Sat, 29 May 2021 09:25:48 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.10.2
MIME-Version: 1.0
In-Reply-To: <988e2438-c322-c1d5-ca88-683943a80087@mailpen.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/1a2f01ce-b3da-3066-0642-3e311587ece3%40aklaver.com>
Precedence: bulk

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