Re: TOAST table performance problem

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

​