Re: Planning performance problem (67626.278ms)

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: Krzysztof Plocharz <plocharz(at)9livesdata(dot)com>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Planning performance problem (67626.278ms)
Date: 2019-04-08 22:10:56
Message-ID: 20190408221056.GR10080@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Apr 08, 2019 at 04:55:36PM +0200, Krzysztof Plocharz wrote:
> We did pgrepack and it did help, but is it possible for
> get_actual_variable_range to take over 60 seconds?

You have many tables being joined, perhaps in exhaustive search, so maybe
that's being called many times.

What version postgres server ?

Justin

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gavin Flower 2019-04-08 22:31:15 Re: Oracle to postgres migration
Previous Message legrand legrand 2019-04-08 20:02:36 Re: Oracle to postgres migration