RE: Big performance slowdown from 11.2 to 13.3

[l...@laurent-hasson.com]

-----Original Message-----
From: Justin Pryzby <pry...@telsasoft.com> 
Sent: Thursday, July 22, 2021 12:23
To: l...@laurent-hasson.com
Cc: Tom Lane <t...@sss.pgh.pa.us>; David Rowley <dgrowle...@gmail.com>; Peter 
Geoghegan <p...@bowt.ie>; pgsql-performa...@postgresql.org
Subject: Re: Big performance slowdown from 11.2 to 13.3

On Thu, Jul 22, 2021 at 04:16:34PM +0000, l...@laurent-hasson.com 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.