Abnormal JSON query performance - Mailing list pgsql-bugs

From David G. Johnston
Subject Abnormal JSON query performance
Date
Msg-id CAKFQuwZJWJDEQsAM0OMKEqNV9P-UfZs-UOL=0Ri6pwSAL8DoQQ@mail.gmail.com
Whole thread Raw
In response to Re: Abnormal JSON query performance  (007reader@gmail.com)
Responses Re: Abnormal JSON query performance
List pgsql-bugs
On Sunday, May 13, 2018, <007reader@gmail.com> wrote: 
My interest is in fast access to data. On a relational table, the query time is about the same whether I have one or ten fields in a select statement. I’d love to see the same behavior when getting multiple keys from a JSON document.

I would hazard to say this is a solid desire and one shared by many.  It is also seemingly something that today has little or no precedent in PostgreSQL.  The lack is not a bug.  Trying to use PostgreSQL in ways contrary to a normalized relational database forces one to decide between convenice of the platform versus suboptimal implementation when dealing with this kind of situation.  Discussion of those dynamics is better done on the -general list, not -bugs.

David J.

pgsql-bugs by date:

Previous
From: 007reader@gmail.com
Date:
Subject: Re: Abnormal JSON query performance
Next
From: Pavel Stehule
Date:
Subject: Re: Abnormal JSON query performance