From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | agarwal3akshay(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #17472: Jsonb[] operations not working |
Date: | 2022-04-29 09:40:48 |
Message-ID: | CAFj8pRDbGkHWi=MUEpV8N-2XQG45bPLzMAyZWJzqv9SLpcKAQQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi
pá 29. 4. 2022 v 11:03 odesílatel PG Bug reporting form <
noreply(at)postgresql(dot)org> napsal:
> The following bug has been logged on the website:
>
> Bug reference: 17472
> Logged by: Akshay Agarwal
> Email address: agarwal3akshay(at)gmail(dot)com
> PostgreSQL version: 14.2
> Operating system: Windows
> Description:
>
> The jsonb[] type of columns are not supporting any kind of deletion
> operations.
> Since jsonb supports array of json objects, why jsonb[] was created? is
> there any difference in the performance of the same?
>
This is not a bug. Arrays are supported for almost all types in Postgres.
It is a generic feature. Just json can hold arrays too, and from PostgreSQL
14 Postgres allows to use similar interface.
If jsonb arrays are faster than Postgres arrays? It depends on the task and
environment. The update of a jsonb array can have the same speed as an
update of a generic array in SQL, but generic arrays have special support
in PL/pgSQL, and there can be significant differences in performance.
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Joe Hebert (jhebert) | 2022-04-29 17:34:44 | RE: [EXT] Re: BUG #17469: postgresql-11.service file not configured to match setup/initdb options specified |
Previous Message | PG Bug reporting form | 2022-04-29 07:03:04 | BUG #17472: Jsonb[] operations not working |