Re: TOAST table performance problem

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

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@xxxxxxxxx>:

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@xxxxxxxxxx>, 7 Şub 2020 Cum, 17:42 tarihinde şunu yazdı:

På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy <ayisan1096@xxxxxxxxx>:

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.