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

Поиск
Список
Период
Сортировка
От avinash varma
Тема Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Дата
Msg-id CADaHE9Hw=rXF-bciEFKxzpwdAZUFnT1sofw-kPAUn6WXUF1LUA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Planning time is high in Postgres 11.5 Compared with Postgres10.11  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-bugs
Дерево обсуждения
>> 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16169: Default time output for 24:00 is 00:00
Следующее
От: Roman Cervenak
Дата:
Сообщение: Re: Memory leak (possibly connected to postgis) leading to server crash