Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6bTT-0004Kl-1j for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 16:23:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6bTS-00082B-0O for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 16:23:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6bTR-00081s-LQ for pgsql-performance@lists.postgresql.org; Thu, 22 Jul 2021 16:23:01 +0000 Received: from mail-il1-x132.google.com ([2607:f8b0:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6bTN-0000y9-U8 for pgsql-performance@postgresql.org; Thu, 22 Jul 2021 16:23:01 +0000 Received: by mail-il1-x132.google.com with SMTP id j5so5906210ilk.3 for ; Thu, 22 Jul 2021 09:22:57 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=0W2fLIw24/41jeKvBoyTGt2a1md9AX4ZyysWzkdw9Ic=; b=tTu9C5b+QmWM4tyeYHnH7FLZQa3xxG3A7V7JAsLsx9WHd1GxRdddCjEPMEarGs3xmT zS2Lx2CsU0nHwgmCnT6ku2HVYpJ3dUsU88r7JLV6FFX45NR5NAEEAs0JlIoAlppmJR8U bJTjbpvP/e+a5MSQHVwgTnWxmOuRxP71+ZNalwyrLYGd7q3F/fW8nTeSNxZhb+M/XmNG lQAq8dD7tgUIAhm91MAUwnP62A/a3p+F5h8wNngdPYv7SjQiwX0lrKXjaM8X8Cw8OYua KWPI1UTblqwpS6an+TDl1CNyTxeyiv3Vahc/qIn/7a15abrsOqrJbXo33RAaEG1uUXh9 Ro/A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=0W2fLIw24/41jeKvBoyTGt2a1md9AX4ZyysWzkdw9Ic=; b=GSqguBnXrS1rezGQhQUUfAc6QNYH4eaOEOIrbtWxTwK2+0Ge6XJIsn1B+WUjPr/pq3 xcIqf5WbLX+P8mUAbyJ2AvwN+7OpglEpuePDGujygf/eaBG+GYqsDZdFqF6jqjiKbJDk ZbL5WVB2cHev56RU+s1DLfomgk264AGJp5lFwSAu+6kN4WPbDDg2aQ896u5M2P7a183I cZY6ABcbjyTe2x2gUgxHtXvvmNFsxox+3eRJpQpv1TvxE97vyn/X/FbwHDtQ2suDsFZh fZfXVAXNiPED44atxwMyhLGTo0CKFCMc1skiPtx/K9b2LfPyf1zhf9+OmU5oq+OFAIEw LX0A== X-Gm-Message-State: AOAM532uBxEf177mQzytPicY19jupHD/weRIBJMXAfVA1UwkAHbRr7l1 3uu0hcaKie0OpJqv73ORpKSYwA== X-Google-Smtp-Source: ABdhPJzuWkKNfy5+PxBhU2U02m1XeM01NZLHkttA2N7w2iQTXRe7xF0AnpbgQI+GNQ7E9f/Jka8FBw== X-Received: by 2002:a92:c8c5:: with SMTP id c5mr418961ilq.1.1626970976254; Thu, 22 Jul 2021 09:22:56 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id p6sm15025283ilg.4.2021.07.22.09.22.55 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 22 Jul 2021 09:22:55 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 0C561800DAB; Thu, 22 Jul 2021 11:22:55 -0500 (CDT) Date: Thu, 22 Jul 2021 11:22:54 -0500 From: Justin Pryzby To: ldh@laurent-hasson.com Cc: Tom Lane , David Rowley , Peter Geoghegan , pgsql-performance@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 Message-ID: <20210722162254.GG19620@telsasoft.com> References: <732758.1626911007@sss.pgh.pa.us> <784576.1626968702@sss.pgh.pa.us> <785218.1626969409@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Jul 22, 2021 at 04:16:34PM +0000, ldh@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