Re: Jsonb extraction very slow

Поиск
Список
Период
Сортировка
От hari.prasath
Тема Re: Jsonb extraction very slow
Дата
Msg-id 1567d050e6e.c23a53313551.8323271350561778673@zohocorp.com
обсуждение исходный текст
Ответ на Re: Jsonb extraction very slow  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>What were you doing to "get ten keys out"? If those were ten separate 
>JSON operators, they'd likely have done ten separate decompressions. 
>You'd have saved something by having the TOAST data already fetched into 
>shared buffers, but it'd still hardly be free. 

Now i got the point. Initially, i thought for n keys to extract from json only one time the full json is decompressed. But it's actually decompressing n times for n keys.


Thanks
- Harry

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

Предыдущее
От: "Yelai, Ramkumar"
Дата:
Сообщение: pgbasebackup is failing after truncate
Следующее
От: James Sewell
Дата:
Сообщение: Standby crash