Postgres Pro
Downloads
Home   >   mailing lists

Prepared statements generating a lot of temp files. - Mailing list pgsql-admin

From Karthik Krishnakumar
Subject Prepared statements generating a lot of temp files.
Date
Msg-id 1870db7265d.f259eb2750325.860651782313663792@zohocorp.com
Whole thread Raw
Responses Re: Prepared statements generating a lot of temp files.  ("Michaeldba@sqlexec.com" <Michaeldba@sqlexec.com>)
List pgsql-admin
Tree view
Hi admins,

I am analyzing temp files being generated using pg_badger.
Under "queries generating the most temporary files", I am finding insert/update 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 ?

thanks,
karthik

pgsql-admin by date:

Previous
From: Sbob
Date:
Subject: Re: Logical Replication Setup using one replication slot per table? SOLVED
Next
From: "Michaeldba@sqlexec.com"
Date:
Subject: Re: Prepared statements generating a lot of temp files.