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