| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | "Dean Gibson (DB Administrator)" <postgresql(at)mailpen(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: AWS forcing PG upgrade from v9.6 a disaster |
| Date: | 2021-05-29 16:25:48 |
| Message-ID: | 1a2f01ce-b3da-3066-0642-3e311587ece3@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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:
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(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laura Smith | 2021-05-29 16:34:23 | Re: Overriding natural order of query results for a subset |
| Previous Message | Adrian Klaver | 2021-05-29 16:06:00 | Re: Overriding natural order of query results for a subset |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Gibson (DB Administrator) | 2021-05-29 19:59:47 | Re: AWS forcing PG upgrade from v9.6 a disaster |
| Previous Message | Jan Wieck | 2021-05-29 11:39:29 | Re: AWS forcing PG upgrade from v9.6 a disaster |