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

avinash varma <[email protected]> Tue, 17 Dec 2019 17:04:18 +0530

Newsgroups	gmane.comp.db.postgresql.bugs
Message-ID	<CADaHE9Hw=rXF-bciEFKxzpwdAZUFnT1sofw-kPAUn6WXUF1LUA@mail.gmail.com>

>> b) can you compare size of databases, indexes?
I used the same backup  to restore on V10 and V11 . So the no: of indexes
and size of databases are same.

One observation is that after pg_restore, we are doing vacuum full analyze
on both V10 and V11.

This is causing the slowness on V11 . Before vacuum analyze , same query is
performing well on V11.

Is there any changes in the analyze script in V11 when compared to V10.

Thanks,
Avinash