pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Dean Gibson (DB Administrator) <postgresql@mailpen.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: AWS forcing PG upgrade from v9.6 a disaster
Date: Sat, 29 May 2021 09:25:48 -0700
Message-ID: <1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com> (raw)
In-Reply-To: <988e2438-c322-c1d5-ca88-683943a80087@mailpen.com>
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>

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





view thread (54+ messages)  latest in thread

Message-ID: <1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com>
Permalink:  ../1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com/
Also on:    postgresql.org/message-id/1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: adrian.klaver@aklaver.com, postgresql@mailpen.com, pgsql-general@lists.postgresql.org
  Subject: Re: AWS forcing PG upgrade from v9.6 a disaster
  In-Reply-To: <1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox