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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: 007reader@gmail.com
Дата:
Сообщение: Re: Abnormal JSON query performance
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Abnormal JSON query performance