Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6
 vs 10.10
To: Mukesh Chhatani <chhatani.mukesh@gmail.com>,
 Andres Freund <andres@anarazel.de>
Cc: pgsql-bugs@lists.postgresql.org
References: <16109-26a1a88651e90608@postgresql.org>
 <20191112205506.rvadbx2dnku3paaw@alap3.anarazel.de>
 <CACnmOYLj6PsfVKe6+mgmM5vsZtQQjx8HdogYB4d5uCiNPjXmQw@mail.gmail.com>
From: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Organization: Postgres Professional
Message-ID: <25c7ebae-a3e9-5c79-23f6-cb183045d79b@postgrespro.ru>
Date: Wed, 13 Nov 2019 09:58:28 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.2.1
MIME-Version: 1.0
In-Reply-To: 
 <CACnmOYLj6PsfVKe6+mgmM5vsZtQQjx8HdogYB4d5uCiNPjXmQw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Precedence: bulk


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