Postgres Pro
Downloads
Home   >   mailing lists

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

From avinash varma
Subject Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Date
Msg-id CADaHE9Hw=rXF-bciEFKxzpwdAZUFnT1sofw-kPAUn6WXUF1LUA@mail.gmail.com
Whole thread Raw
In response to Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Planning time is high in Postgres 11.5 Compared with Postgres10.11  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-bugs
Tree view
>> 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







pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16169: Default time output for 24:00 is 00:00
Next
From: Roman Cervenak
Date:
Subject: Re: Memory leak (possibly connected to postgis) leading to server crash