Re: [PERFORM] performance drop after upgrade (9.6 > 10)

From: Alvaro Herrera
Subject: Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Date: ,
Msg-id: 20171024161715.admzmcnbpagm6yvf@alvherre.pgsql
(view: Whole thread, Raw)
In response to: Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (johannes graën)
List: pgsql-performance

Tree view

[PERFORM] performance drop after upgrade (9.6 > 10)  (johannes graën, )
 Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Pavel Stehule, )
  Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (johannes graën, )
   Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (johannes graën, )
    Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Justin Pryzby, )
     Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Johannes Graën, )
    Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Alvaro Herrera <-ip.org>, )
    Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Justin Pryzby, )
     Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Bruce Momjian, )

johannes graën wrote:
> 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.

https://wiki.postgresql.org/wiki/Slow_Query_Questions

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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


pgsql-performance by date:

From: Alvaro Herrera
Date:
Subject: Re: [PERFORM] performance drop after upgrade (9.6 > 10)
From: Justin Pryzby
Date:
Subject: Re: [PERFORM] performance drop after upgrade (9.6 > 10)