Content-Type: multipart/alternative;
 boundary=Apple-Mail-031A71FD-D870-4F9F-A9F8-3681C52C9DE9
Content-Transfer-Encoding: 7bit
From: "Michaeldba@sqlexec.com" <Michaeldba@sqlexec.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Prepared statements generating a lot of temp files.
Date: Thu, 23 Mar 2023 05:13:19 -0400
Message-Id: <5267BF6F-73F8-4B94-94EA-F1A6A84DB5EB@sqlexec.com>
References: <1870db7265d.f259eb2750325.860651782313663792@zohocorp.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
In-Reply-To: <1870db7265d.f259eb2750325.860651782313663792@zohocorp.com>
To: Karthik Krishnakumar <karthikk@zohocorp.com>
UI-OutboundReport: notjunk:1;M01:P0:dowsE0vQ1ho=;BrGnLPHqZs/umiINhb2Q8MdzE64
 ve89bsj7qD8W1tBX74c8LPTUIl0bxf+AfjRkXEaqNMqRz9BEIsGpcy1+XxyNP3lJ1Id07XFNe
 LxG9JpL8G4m9xHssFHOD23ymkenpcVVrWHhGSaPMwWn/YPQUKAbzLG/e82JWmrzPpZsbQihL4
 pKgcUBsnMMWTJ1hX2VgE5Y7kcPNz/zBIDjMaomIdpG8iSxv4W87D3Q8H15r8VP5RKo7gbGi++
 SqmQoDIwiwWFea2eZp7knWLgQshJtwVkrsd1+B2yWLeWg2HzFPU5CnnalASVxJkpd/XEniys5
 mqlzuSDf1iPEsLNrqNNw6EhkwI4TGa+58jF9/F09CnmH8BwWbDMS4L8peBJpRn8Ddcm/SzV84
 +mJcsIKodou8VThiToxQofhRoGHIdKYnzYAUAioYwImrSz5lWMybJ6GjZQxV1bHOXZM9SRLUP
 Bm/ny+SkTIu/yYrg0eI8lrJlMrFnR05ug6lJhMd+jo5fmHfVuCG1B9oIBu8c7VWLIN5NVUb++
 YwRt4Cbmsnc5KccpRGalwpM2NzrZl9vDxM2Ze9Td+m6Otqmx9cWAVKorX6qVUxBOUsbCf36lU
 +joutVSN9eLauEnLZpUAdEISrQRpZUnX+FdFpLRcgatu+P2xoVs0p86rbCVgSCTCZuMzk8XVF
 cm+H9/6fU6THz0flFGOxvEi9Fu1a14tFEglfmPvp1Q==
Archived-At: 
 <https://www.postgresql.org/message-id/5267BF6F-73F8-4B94-94EA-F1A6A84DB5EB%40sqlexec.com>
Precedence: bulk


--Apple-Mail-031A71FD-D870-4F9F-A9F8-3681C52C9DE9
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Look at the size of the bind variables and also whether you are doing bulk i=
nserts

Sent from my iPad

> On Mar 23, 2023, at 5:10 AM, Karthik Krishnakumar <karthikk@zohocorp.com> w=
rote:
>=20
> =EF=BB=BF
> Hi admins,=20
>=20
> I am analyzing temp files being generated using pg_badger.
> Under "queries generating the most temporary files", I am finding insert/u=
pdate queries (via prepared statements) writing a lot of data to temp files.=

> I am trying to figure why inserts are generating such temp files.
> Why are inserts/updates generating temp files?
> what can be done to avoid this ?
>=20
> thanks,=20
> karthik
>=20

--Apple-Mail-031A71FD-D870-4F9F-A9F8-3681C52C9DE9
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Look at the size of the bind variables and a=
lso whether you are doing bulk inserts<br><br><div dir=3D"ltr">Sent from my i=
Pad</div><div dir=3D"ltr"><br><blockquote type=3D"cite">On Mar 23, 2023, at 5=
:10 AM, Karthik Krishnakumar &lt;karthikk@zohocorp.com&gt; wrote:<br><br></b=
lockquote></div><blockquote type=3D"cite"><div dir=3D"ltr">=EF=BB=BF<meta co=
ntent=3D"text/html;charset=3DUTF-8" http-equiv=3D"Content-Type"><div style=3D=
"font-size: 10pt;"><div>Hi admins, <br></div><div><br></div><div>I am analyz=
ing temp files being generated using pg_badger.<br></div><div>Under "queries=
 generating the most temporary files", I am finding insert/update queries (v=
ia prepared statements) writing a lot of data to temp files.<br></div><div>I=
 am trying to figure why inserts are generating such temp files.<br></div><d=
iv>Why are inserts/updates generating temp files?<br></div><div> what can be=
 done to avoid this ?<br></div><div><br></div><div>thanks, <br></div><div>ka=
rthik<br></div></div><br></div></blockquote></body></html>=

--Apple-Mail-031A71FD-D870-4F9F-A9F8-3681C52C9DE9--