public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tomas Vondra <[email protected]>
To: Achilleas Mantzios - cloud <[email protected]>
To: [email protected]
Subject: Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
Date: Tue, 12 Nov 2024 14:17:53 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On 11/12/24 11:37, Achilleas Mantzios - cloud wrote:
>
> ...
> 
> We run perf on both systems for 90 seconds to make sure that it included
> at least two runs of the slow system, and we attach both outputs. We run
> perf as :
> 
> sudo perf record -g -p <PID> -- sleep 90
> 
> it strikes me that we dont find similarities between the two, but we are
> new to perf.
> 

Not sure, but it seems the slow profile has a lot of writes. Not sure
why. Do both instances have the same work_mem value / available memory,
storatge?

Maybe EXPLAIN VERBOSE would show if the remote query is the same ...

Maybe try setting log_temp_files=0 before running the query. Writing the
foreign scan result set into a temp file could be happening on one of
the machines only.


regards

-- 
Tomas Vondra

view thread (13+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox