Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11

Tom Lane <[email protected]> Mon, 16 Dec 2019 11:16:54 -0500
Newsgroups gmane.comp.db.postgresql.bugs
Message-ID <[email protected]>
avinash varma <[email protected]> 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