From: | Asya Nevra Buyuksoy <ayisan1096(at)gmail(dot)com> |
---|---|
To: | Andreas Joseph Krogh <andreas(at)visena(dot)com> |
Cc: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | Re: TOAST table performance problem |
Date: | 2020-02-07 14:59:05 |
Message-ID: | CADA48rGx3LRm84hT72_QK5MFvaQ26=4o7U75i7fDDpxYbYzVaA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)visena(dot)com>, 7 Şub 2020 Cum, 17:42 tarihinde
şunu yazdı:
> På fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy <
> ayisan1096(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Joseph Krogh | 2020-02-07 15:15:48 | Re: TOAST table performance problem |
Previous Message | Andreas Joseph Krogh | 2020-02-07 14:42:43 | Re: TOAST table performance problem |