Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] performance drop after upgrade (9.6 > 10) - Mailing list pgsql-performance

From johannes graën
Subject Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Date
Msg-id CA++JNSfTEifSiBq73zpGCQuDNGr9yYcjmkx_=LtAbnadKLY_vg@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (johannes graën <johannes@selfnet.de>)
Responses Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Justin Pryzby <pryzby@telsasoft.com>)
Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view 
Hi Pavel, *,

you were right with ANALYZing the DB first. However, even after doing
so, I frequently see Seq Scans where an index was used before. This
usually cooccurs with parallelization and looked different before
upgrading to 10. I can provide an example for 10 [1], but I cannot
generate a query plan for 9.6 anymore.

Any ideas what makes the new version more seqscanny?


[1] https://explain.depesz.com/s/gXD3


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Purav Chovatia
Date:
Subject: Re: [PERFORM] postgresql tuning with perf
Next
From: legrand legrand
Date:
Subject: Re: [PERFORM] postgresql tuning with perf