RE: Big performance slowdown from 11.2 to 13.3

Thu, 22 Jul 2021 09:30:23 -0700 


-----Original Message-----
From: Justin Pryzby <[email protected]> 
Sent: Thursday, July 22, 2021 12:23
To: [email protected]
Cc: Tom Lane <[email protected]>; David Rowley <[email protected]>; Peter 
Geoghegan <[email protected]>; [email protected]
Subject: Re: Big performance slowdown from 11.2 to 13.3

On Thu, Jul 22, 2021 at 04:16:34PM +0000, [email protected] wrote:
> Is it fair then to deduce that the total memory usage would be 2,400,305kB + 
> 126,560kB? Is this what under the covers V11 is consuming more or less?

It might be helpful to know how much RAM v11 is using.

Could you run the query with log_executor_stats=on; client_min_messages=debug;

The interesting part is this:
!       7808 kB max resident size

-- 
Justin


-------------------------------------------

Hello Justin,

> log_executor_stats=on; client_min_messages=debug;

Would the results then come in EXPLAIN or would I need to pick something up 
from the logs?

Thank you,
Laurent.

































					Reply via email to