agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedFrom: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
To: Mukesh Chhatani <chhatani.mukesh@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10
Date: Wed, 13 Nov 2019 09:58:28 +0300
Message-ID: <25c7ebae-a3e9-5c79-23f6-cb183045d79b@postgrespro.ru> (raw)
In-Reply-To: <CACnmOYLj6PsfVKe6+mgmM5vsZtQQjx8HdogYB4d5uCiNPjXmQw@mail.gmail.com>
References: <16109-26a1a88651e90608@postgresql.org>
<20191112205506.rvadbx2dnku3paaw@alap3.anarazel.de>
<CACnmOYLj6PsfVKe6+mgmM5vsZtQQjx8HdogYB4d5uCiNPjXmQw@mail.gmail.com>
13.11.2019 00:01, Mukesh Chhatani пишет:
> Thanks for getting back to me so quickly
>
> Queries are same and executed in 2 different environments. There are no
> long running queries on any of the environments since they are idle
> right away for my testing.
>
> I can try full vacuum if that is recommended since I tried vacuum
> analyze on the whole database in both environments.
>
> Datases have the same content and size is also same.
>
> Sorry but I am never seen this before , if the sizes vary or if the
> content varies I have seen execution time being slow and not the
> planning time.
>
> I am working on a dataset which I will share for further investigation
> and analysis.
Interesting. I will be waiting for your data set.
--
Andrey Lepikhov
Postgres Professional
https://postgrespro.com
The Russian Postgres Company
view thread (20+ messages) latest in thread
Message-ID: <25c7ebae-a3e9-5c79-23f6-cb183045d79b@postgrespro.ru>
Permalink: ../25c7ebae-a3e9-5c79-23f6-cb183045d79b@postgrespro.ru/
Also on: postgresql.org/message-id/25c7ebae-a3e9-5c79-23f6-cb183045d79b@postgrespro.ru
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: a.lepikhov@postgrespro.ru, chhatani.mukesh@gmail.com, andres@anarazel.de, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10
In-Reply-To: <25c7ebae-a3e9-5c79-23f6-cb183045d79b@postgrespro.ru>
* 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