From: Andreas Joseph Krogh <andreas@visena.com>
To: Asya Nevra Buyuksoy <ayisan1096@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: TOAST table performance problem
Date: Fri, 07 Feb 2020 16:15:48 +0100
Message-ID: <9CE9EAEF-4DD1-4FCF-9B22-7609CBA83021@visena.com> (raw)
In-Reply-To: <CADA48rGx3LRm84hT72_QK5MFvaQ26=4o7U75i7fDDpxYbYzVaA@mail.gmail.com>
References: <CADA48rEizH8wGCCRdfWQYT0q__jeDHFHHKMeb6Z=imqmfyQejw@mail.gmail.com>
<VisenaEmail.28.a032595c9fdf4345.17020191d94@tc7-visena>
<CADA48rGx3LRm84hT72_QK5MFvaQ26=4o7U75i7fDDpxYbYzVaA@mail.gmail.com>
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@gmail.com>:
>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
>>
>>
--
Sendt fra min Android-enhet med K-9 e-post. Unnskyld min kortfattethet.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas@visena.com, ayisan1096@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: TOAST table performance problem
In-Reply-To: <9CE9EAEF-4DD1-4FCF-9B22-7609CBA83021@visena.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox