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 1j03RC-00042G-QM
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2020 13:12:51 +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 1j03RA-0003RP-LZ
	for pgsql-performance@arkaria.postgresql.org; Fri, 07 Feb 2020 13:12: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 1j03RA-0003RI-87
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 13:12: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 1j03R4-0006cA-3t
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 13:12:47 +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:To:From:Date;
 bh=LqhCUXU+kjPOSFsDLa8NZXRS6gsfBmEQHUMjhvwrPSU=;
	b=PxV+tjhOO/59N6U8KPlUU9iw3MqybhhJvirm+wQCvF2sOnPLrGZb6b3q5iw1JiSMqU4AUReBmEdODypUVctD4L3iKN8WCRTLjJUerOtBB0n9+pHT8nI+77/6mhct3JrzX4lMnr2rGbbiqbA+ZfZQoifoWKCYJ9wUSkOfasZIAhw=;
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 1j03R1-0003ql-FV
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 14:12:41 +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 1j03R1-0001Y8-De
	for pgsql-performance@lists.postgresql.org; Fri, 07 Feb 2020 14:12:39 +0100
Date: Fri, 7 Feb 2020 14:12:39 +0100 (CET)
From: Andreas Joseph Krogh <andreas@visena.com>
To: pgsql-performance@lists.postgresql.org
Message-ID: <VisenaEmail.20.1475faa5bbe9a305.1701fc5e097@tc7-visena>
In-Reply-To: 
 <CADA48rGrp8exg1tjpen313+cDYsgDfoFyEvZxpEN=BOY3THsyg@mail.gmail.com>
Subject: Sv: TOAST table performance problem
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----=_Part_160_602245720.1581081159343"
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_160_602245720.1581081159343
Content-Type: multipart/related;
	boundary="----=_Part_161_906530263.1581081159343"

------=_Part_161_906530263.1581081159343
Content-Type: multipart/alternative;
	boundary="----=_Part_162_235771556.1581081159370"

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


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

Hello everybody,

[...]

How I can achieve good performance?


Nobody here understands anything unless you show the exact query and schema=
...=20

And of course you'll be encurraged to upgrade to latest version (12.1) as=
=20
9.4.1 is now 5 years old..=20


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

<div>P=C3=A5 fredag 07. februar 2020 kl. 14:07:28, 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">
<p class=3D"MsoNormal" style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font=
-family:Calibri,sans-serif">Hello everybody,</p>

<p class=3D"MsoNormal" style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font=
-family:Calibri,sans-serif">[...]</p>

<p class=3D"MsoNormal" style=3D"margin:0cm 0cm 0.0001pt;font-size:11pt;font=
-family:Calibri,sans-serif"><span style=3D"background-image:initial;backgro=
und-position:initial;background-size:initial;background-repeat:initial;back=
ground-origin:initial;background-clip:initial">How I can achieve good perfo=
rmance?</span></p>
</div>
</blockquote>

<div>=C2=A0</div>

<div>Nobody here understands anything unless you show the exact query and s=
chema...</div>

<div>=C2=A0</div>

<div>And of course you'll be encurraged to upgrade to latest version (12.1)=
 as 9.4.1 is now 5 years old..</div>

<div>=C2=A0</div>

<div class=3D"visena-email-signature" data-visena-message-id=3D"&lt;VisenaE=
mail.20.1475faa5bbe9a305.1701fc5e097@tc7-visena>">
<div>--<br>
Andreas Joseph Krogh</div>
</div>
------=_Part_162_235771556.1581081159370--

------=_Part_161_906530263.1581081159343--

------=_Part_160_602245720.1581081159343--