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

From: avinash varma <avinashvarma443(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Planning time is high in Postgres 11.5 Compared with Postgres 10.11
Date: 2019-12-17 11:34:18
Message-ID: CADaHE9Hw=rXF-bciEFKxzpwdAZUFnT1sofw-kPAUn6WXUF1LUA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Roman Cervenak 2019-12-17 11:51:27 Re: Memory leak (possibly connected to postgis) leading to server crash
Previous Message Pavel Stehule 2019-12-17 11:08:33 Re: weird long time query