Abnormal JSON query performance
| От | David G. Johnston |
|---|---|
| Тема | Abnormal JSON query performance |
| Дата | |
| Msg-id | CAKFQuwZJWJDEQsAM0OMKEqNV9P-UfZs-UOL=0Ri6pwSAL8DoQQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Abnormal JSON query performance (007reader@gmail.com) |
| Ответы |
Re: Abnormal JSON query performance
|
| Список | 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 по дате отправления: