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 <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1j04qH-0000pE-TO
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2020 14:42:50 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1j04qG-0004MI-NJ
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2020 14:42:48 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <andreas@visena.com>)
	id 1j04qG-0004MB-D3
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 14:42:48 +0000
Received: from post.visena.com ([46.226.10.50])
	by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128)
	(Exim 4.92)
	(envelope-from <andreas@visena.com>)
	id 1j04qE-0007JZ-Ff
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 14:42:48 +0000
DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=visena.com;
 s=20141101.wh;
	h=Content-Type:MIME-Version:Subject:In-Reply-To:Message-ID:Cc:To:From:Date;
 bh=41DYgYdV3TYBv/Tw6yKtTWVeJ6oJOL8ztoei/1i8/f8=;
	b=rgwprUmGDDFFi0vXekOGKdLEXGreiyrgrC2cDDmS7M0gcaBT0zMBJXLMZtcojxumFp/XqbRRwqkSUdT8nornHDOokbcSw3Jp0OWbm8m+k4CHWb6DQo9k3qt70emEhYvUj5mCfQlGRVNwuRxc6QAnSyjXiFK3pN75lMCobqoRZtI=;
Received: from [10.0.1.10] (helo=tc7-visena.wh.internal.visena.com)
	by post.visena.com with esmtp (Exim 4.82)
	(envelope-from <andreas@visena.com>)
	id 1j04qB-0004X8-SY; Fri, 07 Feb 2020 15:42:45 +0100
Received: from localhost ([127.0.0.1] helo=tc7-visena.wh.internal.visena.com)
	by tc7-visena.wh.internal.visena.com with esmtp (Exim 4.90_1)
	(envelope-from <andreas@visena.com>)
	id 1j04qB-0005H0-Qv; Fri, 07 Feb 2020 15:42:43 +0100
Date: Fri, 7 Feb 2020 15:42:43 +0100 (CET)
From: Andreas Joseph Krogh <andreas@visena.com>
To: Asya Nevra Buyuksoy <ayisan1096@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Message-ID: <VisenaEmail.28.a032595c9fdf4345.17020191d94@tc7-visena>
In-Reply-To: 
 <CADA48rEizH8wGCCRdfWQYT0q__jeDHFHHKMeb6Z=imqmfyQejw@mail.gmail.com>
Subject: Re: TOAST table performance problem
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_190_225150123.1581086563772"
X-Mailer: Visena Mail 2.2.236
X-Spam-Score: -1.0
X-Spam-Report: SpamAssasin (score=-1.0,
 required 5.0 ALL_TRUSTED=-1,HTML_MESSAGE=0.001)
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk

------=_Part_190_225150123.1581086563772
Content-Type: multipart/related;
	boundary="----=_Part_191_403676586.1581086563772"

------=_Part_191_403676586.1581086563772
Content-Type: multipart/alternative;
	boundary="----=_Part_192_975309099.1581086563782"

------=_Part_192_975309099.1581086563782
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable


P=C3=A5 fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyuksoy <
ayisan1096@gmail.com <mailto:ayisan1096@gmail.com>>:=20
I use pgadmin3.=20

Try "psql", it has the lowest overhead (I think). pgAdmin might use time=20
presenting the results etc. which is easy to overlook.=20


--=20
Andreas Joseph Krogh=20

------=_Part_192_975309099.1581086563782
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>P=C3=A5 fredag 07. februar 2020 kl. 15:35:04, skrev Asya Nevra Buyukso=
y &lt;<a href=3D"mailto:ayisan1096@gmail.com">ayisan1096@gmail.com</a>&gt;:=
</div>

<blockquote style=3D"border-left: 1px solid rgb(204, 204, 204); margin: 0pt=
 0pt 0pt 0.8ex; padding-left: 1ex;">
<div dir=3D"ltr">I use pgadmin3.</div>
</blockquote>

<div>=C2=A0</div>

<div>Try &quot;psql&quot;, it has the lowest overhead (I think). pgAdmin mi=
ght use time presenting the results etc. which is easy to overlook.</div>

<div>=C2=A0</div>

<div class=3D"visena-email-signature" data-visena-message-id=3D"&lt;VisenaE=
mail.28.a032595c9fdf4345.17020191d94@tc7-visena>">
<div>--
<div>Andreas Joseph Krogh</div>

<div><span style=3D"font-family: arial, helvetica, sans-serif;">=E2=80=8B</=
span></div>
</div>
</div>
------=_Part_192_975309099.1581086563782--

------=_Part_191_403676586.1581086563772--

------=_Part_190_225150123.1581086563772--