| From: | Johannes Graën <johannes(at)selfnet(dot)de> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: performance drop after upgrade (9.6 > 10) |
| Date: | 2017-10-24 15:57:31 |
| Message-ID: | e0592313-750d-64ea-84cf-699471956729@selfnet.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On 2017-10-24 17:18, Justin Pryzby wrote:
> You could (re)install PG96 alongside PG10 and run a copy of the DB (even from
> your homedir, or on a difference server) and pg_dump |pg_restore the relevant
> tables (just be sure to specify the alternate host/port/user/etc as needed for
> the restore invocation).
I considered that but it is far too expensive just for getting the old
query plan. The database is more than 1 TB big and replaying it from a
dump to another server took us several days, primarily due to the heavy
use of materialized views that are calculated over all rows of some
large tables. As long as there is no safe pg_downgrade --link I'd rather
keep trying to improve query performance on the current version.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-10-24 16:17:15 | Re: performance drop after upgrade (9.6 > 10) |
| Previous Message | Justin Pryzby | 2017-10-24 15:18:03 | Re: performance drop after upgrade (9.6 > 10) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2017-10-24 16:17:15 | Re: performance drop after upgrade (9.6 > 10) |
| Previous Message | legrand legrand | 2017-10-24 15:21:02 | Re: postgresql tuning with perf |