Re: Fwd: TOAST table performance problem

Got it, thanks! I understand and know it that PostgreSQL is not slow, but I
want to a piece of advice how can I load this data fastly :)

Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br>, 10 Şub 2020 Pzt, 15:31
tarihinde şunu yazdı:

> ---------- Forwarded message ---------
> Gönderen: Asya Nevra Buyuksoy <ayisan1096(at)gmail(dot)com>
> Date: 10 Şub 2020 Pzt, 10:51
> Subject: Re: TOAST table performance problem
> To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
>
>
> I copied my data to the CSV file, yes it is very fast. However, this does
> not solve my problem.
> After deserializing the on the front side, I want to visualize my data on
> the web page effectively.
> When I select my data one by one with a limit clause, the query executes
> 200 ms. For example, If I create a function that takes data with a loop,
> the execution time will be 200 ms*1000=200 sec.
>
>
> Andreas Joseph Krogh <andreas(at)visena(dot)com>, 7 Şub 2020 Cum, 18:15
> tarihinde şunu yazdı:
>
>> Try \o <filename> in psql, to redirect the output to file, and prevent it
>> from processing the json (ie. format it)
>>
>> Den 7. februar 2020 15:59:05 CET, skrev Asya Nevra Buyuksoy <
>> ayisan1096(at)gmail(dot)com>:
>>>
>>> I try it, but there is no enhancement.
>>> I read this link is about TOAST and also its sub_links;
>>> https://blog.gojekengineering.com/a-toast-from-postgresql-83b83d0d0683
>>> When I execute this query, except JSON data like;
>>> SELECT paramuser_id, paramperson_id, paramisdeleted, paramactiontime
>>> FROM zamazin;
>>> It takes 94 ms. :)
>>>
>>>
>>> Andreas Joseph Krogh <andreas(at)visena(dot)com>, 7 Şub 2020 Cum, 17:42
>>> tarihinde şunu yazdı:
>>>
>>>> På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy <
>>>> ayisan1096(at)gmail(dot)com>:
>>>>
>>>> I use pgadmin3.
>>>>
>>>>
>>>> Try "psql", it has the lowest overhead (I think). pgAdmin might use
>>>> time presenting the results etc. which is easy to overlook.
>>>>
>>>> --
>>>> Andreas Joseph Krogh
>>>>
>>>
>> --
>> Sendt fra min Android-enhet med K-9 e-post. Unnskyld min kortfattethet.
>>
>
> What Andreas is trying to say is that it's not PostgreSQL that is slow to
> read the JSON, but your client app that is slow to parse it.
>