>> 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