From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: json accessors |
Date: | 2012-12-05 19:48:07 |
Message-ID: | 50BFA4F7.4070606@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 12/05/2012 01:49 PM, Josh Berkus wrote:
>>> *) xmlpath/jsonpath do searching (and decomposition) but are very
>>> clunky from sql perspective and probably absolutely nogo in terms if
>>> GIST/GIN. postgres spiritually wants to do things via operators and
>>> we should (if possible) at least consider that first
> Why is it a nogo for GiST? Ltree works, doesn't it? If we only support
> equality lookups in what way is a JSON doc different from a collection
> of ltree rows?
>
> We'd probably want to use SP-GiST for better index size/performance, but
> I don't see that this is impossible. Just some difficult code.
>
The set of paths for a single json datum can be huge, as opposed to one
for a single ltree datum. That strikes me as a serious barrier. In any
case, nobody I know of is even offering to do this - when they do we can
look at the design. Until then I'm assuming nothing.
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2012-12-05 19:51:19 | Re: json accessors |
Previous Message | Simon Riggs | 2012-12-05 19:46:14 | Re: PITR potentially broken in 9.2 |