Re: TOAST table performance problem

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
> ​
>

In response to

Responses

Browse pgsql-performance by date

  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