Re: Columns correlation and adaptive query optimization

From: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Columns correlation and adaptive query optimization
Date: 2019-12-24 08:15:40
Message-ID: 1b0b854c-29cb-1440-5d2d-45ad5c2c6c9f@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

New version of patch implicitly adding multicolumn statistic in
auto_explain extension and using it in optimizer for more precise
estimation of join selectivity.
This patch fixes race condition while adding statistics and restricts
generated statistic name to fit in 64 bytes (NameData).

--
Konstantin Knizhnik
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment Content-Type Size
auto_explain_create_statistic-3.patch text/x-patch 18.1 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2019-12-24 08:21:12 Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions
Previous Message Tatsuo Ishii 2019-12-24 08:09:09 Re: Implementing Incremental View Maintenance