More efficient access of JSON array elements?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

PG 12.3.

--

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux