Re: Fwd: TOAST table performance problem - Mailing list pgsql-performance

---------- Forwarded message ---------

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

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