Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j05MM-0002fm-Gd for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2020 15:15:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j05ML-0007bf-AB for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2020 15:15:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j05MK-0007bY-Tf for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 15:15:57 +0000 Received: from post.visena.com ([46.226.10.50]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.92) (envelope-from ) id 1j05MH-0003FL-N0 for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 15:15:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=visena.com; s=20141101.wh; h=Content-Transfer-Encoding:Content-Type:MIME-Version:Message-ID:References:In-Reply-To:Subject:CC:To:From:Date; bh=8HGQwT6mgzWPLDod1rU53Y3n/xqNbh98Ef6axzh4XqY=; b=dDrYsYOdSsJ5jjVNojec8XrMw1iqfjHuR55WRgC6ncjGTh4q4HLQ0TCpOu1GfwcvlUDXsQDek+1sm8HrGMCGsq+yout9q8xQXp+ktxwotVQ7JNAdEGqYStrMup1ie9fNDxq84JqDRN3uyPk+yEtF9a/KphRKegIw4jwvHyQb/4w=; Received: from 77.18.52.144.tmi.telenormobil.no ([77.18.52.144] helo=[127.0.0.1]) by post.visena.com with esmtpsa (TLS1.2:RSA_AES_128_CBC_SHA1:128) (Exim 4.82) (envelope-from ) id 1j05MC-0001sw-Cj; Fri, 07 Feb 2020 16:15:50 +0100 Date: Fri, 07 Feb 2020 16:15:48 +0100 From: Andreas Joseph Krogh To: Asya Nevra Buyuksoy CC: pgsql-performance@lists.postgresql.org Subject: Re: TOAST table performance problem User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: <9CE9EAEF-4DD1-4FCF-9B22-7609CBA83021@visena.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----YBGVUFSN4F40L9MIXDORQYV43RCTRK Content-Transfer-Encoding: 7bit X-Spam-Score: -1.0 X-Spam-Report: SpamAssasin (score=-1.0, required 5.0 ALL_TRUSTED=-1,HTML_MESSAGE=0.001,TVD_RCVD_IP=0.001) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------YBGVUFSN4F40L9MIXDORQYV43RCTRK Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Try \o in psql, to redirect the output to file, and prevent it f= rom processing the json (ie=2E format it) Den 7=2E februar 2020 15:59:05 CET, skrev Asya Nevra Buyuksoy : >I try it, but there is no enhancement=2E >I read this link is about TOAST and also its sub_links; >https://blog=2Egojekengineering=2Ecom/a-toast-from-postgresql-83b83d0d068= 3 >When I execute this query, except JSON data like; >SELECT paramuser_id, paramperson_id, paramisdeleted, paramactiontime > FROM zamazin; >It takes 94 ms=2E :) > > >Andreas Joseph Krogh , 7 =C5=9Eub 2020 Cum, 17:42 t= arihinde >=C5=9Funu yazd=C4=B1: > >> P=C3=A5 fredag 07=2E februar 2020 kl=2E 15:35:04, skrev Asya Nevra Buyu= ksoy < >> ayisan1096@gmail=2Ecom>: >> >> I use pgadmin3=2E >> >> >> Try "psql", it has the lowest overhead (I think)=2E pgAdmin might use t= ime >> presenting the results etc=2E which is easy to overlook=2E >> >> -- >> Andreas Joseph Krogh >> =E2=80=8B >> --=20 Sendt fra min Android-enhet med K-9 e-post=2E Unnskyld min kortfattethet= =2E ------YBGVUFSN4F40L9MIXDORQYV43RCTRK Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Try \o <filename> in psql, to redirect the o= utput to file, and prevent it from processing the json (ie=2E format it)
Den 7=2E februar 2020 15:59:05 CET, skrev A= sya Nevra Buyuksoy <ayisan1096@gmail=2Ecom>:
I try it, but there is no enhancement=2E  
<= div>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=2E :)<= /div>


Andreas Joseph Krogh <andreas@visena=2Ecom>, 7 =C5=9Eub 2020 Cum, 17:42 tarihind= e =C5=9Funu yazd=C4=B1:
P=C3=A5 fredag 07=2E februar 2020 kl=2E 15:35:04, skrev Asya= Nevra Buyuksoy <ayisan1096@gmail=2Ecom>:
I use pgadmin3=2E
 
Try "psql", it has the lowest overhead (I think)=2E pgAdmin might use= time presenting the results etc=2E which is easy to overlook=2E
 
--
Andreas Joseph Krogh
=E2=80=8B

--
Sendt fra min Android-enhet med K-9 e-post= =2E Unnskyld min kortfattethet=2E ------YBGVUFSN4F40L9MIXDORQYV43RCTRK--