Postgres Pro
Downloads
Home   >   mailing lists

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

From Asya Nevra Buyuksoy
Subject Re: TOAST table performance problem
Date
Msg-id CADA48rGx3LRm84hT72_QK5MFvaQ26=4o7U75i7fDDpxYbYzVaA@mail.gmail.com
Whole thread Raw
In response to Re: TOAST table performance problem  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: TOAST table performance problem  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-performance
Tree view
I try it, but there is no enhancement.  
I read this link is about TOAST and also its sub_links;
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
​

pgsql-performance by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: TOAST table performance problem
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: TOAST table performance problem