Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Date
Msg-id 12053.1576513014@sss.pgh.pa.us
Whole thread Raw
In response to Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11  (avinash varma <avinashvarma443@gmail.com>)
Responses Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11  (avinash varma <avinashvarma443@gmail.com>)
List pgsql-bugs
avinash varma <avinashvarma443@gmail.com> writes:
> Actually , we used the same backup to restore on both V10 & V11  , So  the
> data on both the versions is same.
> After restore, we ran vacuum full analyze on both the servers .
> default_statistics_target  value "1000" is same on both the versions.
> Used the same postgresql.conf , i,e it is same on both V10 and V11

You didn't answer the question:

>> First thing to do is to look into pg_stats and see how large those
>> arrays actually are in each case ...

Also, please don't top-post when replying.  It makes it hard for
people to follow the conversation.

            regards, tom lane



pgsql-bugs by date:

Previous
From: avinash varma
Date:
Subject: Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Next
From: Jens.Wilke@parcIT.de
Date:
Subject: Missing locales prevent autovacuum