---------- Forwarded message ---------
Gönderen: *Asya Nevra Buyuksoy* <ayisan1...@gmail.com <mailto:ayisan1...@gmail.com>>
Date: 10 Şub 2020 Pzt, 10:51
Subject: Re: TOAST table performance problem
To: Andreas Joseph Krogh <andr...@visena.com <mailto:andr...@visena.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 <andr...@visena.com <mailto:andr...@visena.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
    <ayisan1...@gmail.com <mailto:ayisan1...@gmail.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 <andr...@visena.com
        <mailto:andr...@visena.com>>, 7 Şub 2020 Cum, 17:42 tarihinde
        şunu yazdı:

            På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra
            Buyuksoy <ayisan1...@gmail.com <mailto:ayisan1...@gmail.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.

Reply via email to