From: Jim Finnerty <jfinnert@amazon.com>
To: pgsql-performance@postgresql.org
Subject: Re: Optimizer choosing the wrong plan
Date: Sat, 29 Dec 2018 05:17:33 -0700 (MST)
Message-ID: <1546085853213-0.post@n3.nabble.com> (raw)
In-Reply-To: <CAMkU=1w2MDqZOvwqeB56vPdc1b0JOsBwPx3xcA8MvF4vzQLdZQ@mail.gmail.com>
References: <1543227078813-0.post@n3.nabble.com>
<CAMkU=1w2MDqZOvwqeB56vPdc1b0JOsBwPx3xcA8MvF4vzQLdZQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jfinnert@amazon.com
Subject: Re: Optimizer choosing the wrong plan
In-Reply-To: <1546085853213-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox