Re: [SQL] Updating jsonb rows

Поиск
Список
Период
Сортировка
От Michael Moore
Тема Re: [SQL] Updating jsonb rows
Дата
Msg-id CACpWLjPhwbSC-BJ3dNrcAFu1FYH4rrJ7n-0t+FzacOJ68SeisA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [SQL] Updating jsonb rows  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [SQL] Updating jsonb rows
Список pgsql-sql
Probably the solution is "don't try to use JSON as temp tables for anything but very small datasets". As you know, I'm converting an application that uses temp tables to NOT use temp tables because it needs to run in a read-only database. JSONB seemed to be the way to go because you can almost treat them the same as temp tables. I think in the end, it will be "fast enough", but just not as fast as temp tables. Thanks for your help!
Mike


On Mon, Aug 14, 2017 at 11:12 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Aug 14, 2017 at 10:35 AM, Michael Moore <michaeljmoore@gmail.com> wrote:
Basically what I am doing is trying to simulate a SQL UPDATE statement. currently I am doing this, and it works, but it is slow, so I am looking for a better way. 

​I don't presently know a better solution in PostgreSQL.

Dave

В списке pgsql-sql по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [SQL] Updating jsonb rows
Следующее
От: Michael Moore
Дата:
Сообщение: Re: [SQL] Updating jsonb rows