| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: More efficient access of JSON array elements? |
| Date: | 2020-07-22 18:42:25 |
| Message-ID: | 20200722184225.GD3899@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Sat, Jul 18, 2020 at 06:22:20PM -0700, Wells Oliver wrote:
> Hi: I'm wondering if there's an application of GIN (or otherwise) indexing with
> jsonb columns to help speed up some queries where I'm not using WHERE clauses,
> but unpacking rather large json objects to rows via jsonb_array_elements: it
> seems indexing largely helps when filtering, but this is more unpacking/
> flattening with really quite sizable objects.
You can use JSON (not JSONB) to get faster loading/unloading, but much
slower filtering.
--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EnterpriseDB https://enterprisedb.com
The usefulness of a cup is in its emptiness, Bruce Lee
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2020-07-22 18:55:41 | Re: Encryption in pg_dump |
| Previous Message | Wells Oliver | 2020-07-22 17:30:29 | Re: Creating trigger with optional arg? |