agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Mukesh Chhatani <chhatani.mukesh@gmail.com>
To: pgsql-bugs@postgresql.org
Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10
Date: Wed, 13 Nov 2019 11:37:30 -0700 (MST)
Message-ID: <1573670250461-0.post@n3.nabble.com> (raw)
In-Reply-To: <16109-26a1a88651e90608@postgresql.org>
References: <16109-26a1a88651e90608@postgresql.org>
All,
Update I was able to resolve the problem by changing - partitioned tables to
single table and changing data type of 2 columns used in the joins from
varchar to varchar(50).
FYI.. default_statistics_target was set to 10000 but I changed it 100 and
even to 1000 and still planning time was high.
Still working on the dataset so that more people can investigate the issues.
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html
view thread (20+ messages) latest in thread
Message-ID: <1573670250461-0.post@n3.nabble.com>
Permalink: ../1573670250461-0.post@n3.nabble.com/
Also on: postgresql.org/message-id/1573670250461-0.post@n3.nabble.com
reply
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-bugs@postgresql.org
Cc: chhatani.mukesh@gmail.com
Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10
In-Reply-To: <1573670250461-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 agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox