Re: JSONB spaces in text presentation

Поиск
Список
Период
Сортировка
От Ilya I. Ashchepkov
Тема Re: JSONB spaces in text presentation
Дата
Msg-id CALgmQD8kungXqhQ15VFhg7Jnh7b-3s39_7TJcjPFBJ_sfHpkGw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JSONB spaces in text presentation  (John R Pierce <pierce@hogranch.com>)
Ответы Re: JSONB spaces in text presentation  (Merlin Moncure <mmoncure@gmail.com>)
Re: JSONB spaces in text presentation  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
I'm sorry about sending email several times. I haven't understand, was it sent by gmail or not.


On Wed, Sep 24, 2014 at 2:30 PM, John R Pierce <pierce@hogranch.com> wrote:
On 9/24/2014 12:23 AM, Ilya I. Ashchepkov wrote:

Is spaces is necessary in text presentation of JSONB?
In my data resulting text contains ~12% of spaces.

 can you show us an example of this?

One record
# select data from events.data limit 1;
{"can": {"lls": {"1": 76.4}, "mhs": 4674.85, "rpm": 168.888, "speed": 74, "runned": 166855895, "fuel_consumption": 74213.5}, "crc": 10084, "gps": 1, "gsm": {"signal": 100}, "lls": {"1": 733, "2": 717}, "used": 19, "speed": 87.4, "valid": 1, "msg_id": 89, "runned": 72.75, "boot_no": 256, "digital": {"in": {"1": 1, "2": 0, "3": 0, "4": 0, "5": 0, "6": 0}, "out": {"1": 0, "2": 0}}, "visible": 20, "ignition": 1, "location": {"course": 265, "altitude": 143, "latitude": 55.127888997395836, "longitude": 80.8046142578125}, "protocol": 4, "coldstart": 1, "timesource": "terminal", "receiver_on": 1, "external_power": 28.07, "internal_power": 4.19}

Whitespacis percents in this record:
# select array_length(regexp_split_to_array(data::text, text ' '), 1)*100./length(data::text) from events.data limit 1;
      ?column?
---------------------
 12.3417721518987342

Whitespace in test data
 # select count(*),avg(array_length(regexp_split_to_array(data::text, text ' '), 1)*100./length(data::text)) from events.data ;
 count  |         avg
--------+---------------------
 242222 | 12.3649234646118312




--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
С уважением,
Ащепков Илья koctep@gmail.com

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: JSONB spaces in text presentation
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Synchronous replication + pgPool: not all transactions immediately visible on standby