Date: Fri, 7 Feb 2020 15:19:19 +0100 (CET)
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Message-ID: <VisenaEmail.26.367975a459fd47c9.1702003fe3a@tc7-visena>
In-Reply-To: 
 <CADA48rEzqEWoJhYaTb1PU6C9=Qr8PB-SAUxA=9_vuJa5wv=ZiA@mail.gmail.com>
Subject: Re: TOAST table performance problem
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_185_744001712.1581085159945"
Precedence: bulk

------=_Part_185_744001712.1581085159945
Content-Type: multipart/related;
	boundary="----=_Part_186_646692137.1581085159945"

------=_Part_186_646692137.1581085159945
Content-Type: multipart/alternative;
	boundary="----=_Part_187_1944362348.1581085159956"

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


P=C3=A5 fredag 07. februar 2020 kl. 15:16:13, skrev Asya Nevra Buyuksoy <
ayisan1096@gmail.com <mailto:ayisan1096@gmail.com>>:=20


Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM:=20
P=C3=A5 fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyuksoy <
ayisan1096@gmail.com <mailto:ayisan1096@gmail.com>>:=20


My guess is the time is spent in the client retrieving the data, not in the=
 DB=20
itself. Are you on a slow network?=20
 It works in my local area and speed is 1 Gbps. When I use another local=20
computer that has SSD disk the query execution time reduced to 12 seconds. =
But=20
this query has to execute my local computer.=20

What client are you using?=20


--
 Andreas Joseph Krogh
------=_Part_187_1944362348.1581085159956
Content-Type: text/html;charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>P=C3=A5 fredag 07. februar 2020 kl. 15:16:13, 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">
<div class=3D"gmail_quote">
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><br>
<span>Andreas Joseph Krogh wrote on 2/7/2020 8:41 AM:</span>

<blockquote type=3D"cite">
<div>P=C3=A5 fredag 07. februar 2020 kl. 14:23:35, skrev Asya Nevra Buyukso=
y &lt;<a href=3D"mailto:ayisan1096@gmail.com" target=3D"_blank">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">
<div dir=3D"ltr">=C2=A0</div>
</div>
</blockquote>

<div>My guess is the time is spent in the=C2=A0<em>client</em>=C2=A0retriev=
ing the data, not in the DB itself. Are you on a slow network?</div>
</blockquote>
</blockquote>

<div>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0It works in my =
local area and speed is 1 Gbps. When I use another local computer that has =
SSD disk the query execution time reduced to 12 seconds. But this query has=
 to execute my local computer.</div>
</div>
</div>
</blockquote>

<div>=C2=A0</div>

<div>What client are you using?</div>

<div>=C2=A0</div>

<div class=3D"visena-email-signature" data-visena-message-id=3D"&lt;VisenaE=
mail.26.367975a459fd47c9.1702003fe3a@tc7-visena>">
<div>--<br>
Andreas Joseph Krogh</div>
</div>
------=_Part_187_1944362348.1581085159956--

------=_Part_186_646692137.1581085159945--

------=_Part_185_744001712.1581085159945--