Re: Big performance slowdown from 11.2 to 13.3

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: ldh(at)laurent-hasson(dot)com
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Big performance slowdown from 11.2 to 13.3
Date: 2021-07-22 16:22:54
Message-ID: 20210722162254.GG19620@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Jul 22, 2021 at 04:16:34PM +0000, ldh(at)laurent-hasson(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ldh@laurent-hasson.com 2021-07-22 16:24:40 RE: Big performance slowdown from 11.2 to 13.3
Previous Message Tom Lane 2021-07-22 16:21:38 Re: Big performance slowdown from 11.2 to 13.3