| From: | Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de>, "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Amit Langote <amitlangote09(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, John Naylor <john(dot)naylor(at)enterprisedb(dot)com> |
| Subject: | Re: SQL/JSON features for v15 |
| Date: | 2022-09-01 13:54:42 |
| Message-ID: | 0574201c-bd35-01af-1557-8936f99ce5aa@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 31.08.2022 23:39, Nikita Glukhov wrote:
> And here is a quick POC patch with an example for COPY and float4
I decided to go further and use new API in SQL/JSON functions
(even if it does not make real sense now).
I have added function for checking expressions trees, special
executor steps for handling errors in FuncExpr, CoerceViaIO,
CoerceToDomain which are passed through ExprState.edata.
Of course, there is still a lot of work:
1. JIT for new expression steps
2. Removal of subsidary ExprStates (needs another solution for
ErrorData passing)
3. Checking of domain constraint expressions
4. Error handling in coercion to bytea
5. Error handling in json_populate_type()
6. Error handling in jsonb::type casts
7. ...
Also I have added lazy creation of JSON_VALUE coercions, which was
not present in previous patches. It really greatly speeds up JIT
and reduces memory consumption. But it requires using of subsidary
ExprStates.
jsonb_sqljson test now fails because of points 4, 5, 6.
--
Nikita Glukhov
Postgres Professional:http://www.postgrespro.com
The Russian Postgres Company
| Attachment | Content-Type | Size |
|---|---|---|
| fix-sqljson-executor-v11.tgz | application/x-compressed-tar | 35.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonathan S. Katz | 2022-09-01 14:05:48 | Re: POC: GROUP BY optimization |
| Previous Message | Ranier Vilela | 2022-09-01 13:27:24 | Re: Reducing the chunk header sizes on all memory context types |