Re: Postgres picks suboptimal index after building of an extended statistics

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgres picks suboptimal index after building of an extended statistics
Date: 2021-08-11 00:48:19
Message-ID: CAH2-WznuVaH7EO5GU_VMRziQhxhctXrBkNz3cVRL8d4BN+nStw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 23, 2021 at 7:19 AM Andrey V. Lepikhov
<a(dot)lepikhov(at)postgrespro(dot)ru> wrote:
> Ivan Frolkov reported a problem with choosing a non-optimal index during
> a query optimization. This problem appeared after building of an
> extended statistics.

Any thoughts on this, Tomas?

--
Peter Geoghegan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2021-08-11 01:16:15 Re: Tab completion for CREATE SCHEMAAUTHORIZATION
Previous Message Michael Paquier 2021-08-11 00:47:38 Re: [PATCH] test/ssl: rework the sslfiles Makefile target