Re: Collecting statistics about contents of JSONB columns

From: Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, Mahendra Thalor <mahendra(dot)thalor(at)enterprisedb(dot)com>, Oleg Bartunov <obartunov(at)postgrespro(dot)ru>
Subject: Re: Collecting statistics about contents of JSONB columns
Date: 2022-01-06 19:26:43
Message-ID: f538e760-3543-d70b-4770-23112d567723@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 1/5/22 21:13, Thomas Munro wrote:
> On Sat, Jan 1, 2022 at 11:07 AM Tomas Vondra
> <tomas(dot)vondra(at)enterprisedb(dot)com> wrote:
>> 0006-Add-jsonb-statistics-20211230.patch
>
> Hi Tomas,
>
> -CREATE OR REPLACE FUNCTION explain_jsonb(sql_query text)
> +CREATE OR REPLACE FUNCTION explain_jsonb(sql_query text)
>
> https://cirrus-ci.com/task/6405547984420864
>
> It looks like there is a Unicode BOM sequence in there, which is
> upsetting our Windows testing but not the 3 Unixes (not sure why).
> Probably added by an editor.
>

Thanks, fixed along with some whitespace issues.

regards

--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment Content-Type Size
0001-Add-pg_operator.oprstat-for-derived-operato-20220106.patch text/x-patch 12.3 KB
0002-Add-stats_form_tuple-20220106.patch text/x-patch 3.9 KB
0003-Add-symbolic-names-for-some-jsonb-operators-20220106.patch text/x-patch 7.1 KB
0004-Add-helper-jsonb-functions-and-macros-20220106.patch text/x-patch 9.7 KB
0005-Export-scalarineqsel-20220106.patch text/x-patch 1.5 KB
0006-Add-jsonb-statistics-20220106.patch text/x-patch 121.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2022-01-06 19:48:39 Re: Collecting statistics about contents of JSONB columns
Previous Message Pavel Stehule 2022-01-06 19:24:17 Re: pl/pgsql feature request: shorthand for argument and local variable references