Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer choosing the wrong plan - Mailing list pgsql-performance

From Jim Finnerty
Subject Re: Optimizer choosing the wrong plan
Date
Msg-id 1546085853213-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Optimizer choosing the wrong plan  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Optimizer choosing the wrong plan
List pgsql-performance
Tree view 
re: It would interesting if you can upgrade a copy of your server to v11 and
try it there.  We made changes to ANALYZE in that version which were
intended to improve this situation, and it would be nice to know if it
actually did so for your case.  

Jeff, can you describe the changes that were made to ANALYZE in v11, please?

I've found that running ANALYZE on v10 on the Join Order Benchmark, using
the default statistics target of 100, produces quite unstable results, so
I'd be interested to hear what has been improved in v11.

    /Jim



-----
Jim Finnerty, AWS, Amazon Aurora PostgreSQL
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

pgsql-performance by date:

Previous
From: Jim Finnerty
Date:
Subject: Re: Query Performance Issue
Next
From: Jeff Janes
Date:
Subject: Re: Optimizer choosing the wrong plan