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 1m6cVc-0006vm-Be for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 17:29:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6cVb-0002np-B0 for pgsql-performance@arkaria.postgresql.org; Thu, 22 Jul 2021 17:29:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6cVF-0004jL-6r for pgsql-performance@lists.postgresql.org; Thu, 22 Jul 2021 17:28:57 +0000 Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6cVC-0001O4-M8 for pgsql-performance@postgresql.org; Thu, 22 Jul 2021 17:28:56 +0000 Received: by mail-io1-xd2f.google.com with SMTP id p186so7224188iod.13 for ; Thu, 22 Jul 2021 10:28:54 -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=GcUm6RLTEeD3KgJPy4/UddPSpkNsBUG2+AXODsI8Pv8=; b=rZSjgqhmWAQGMkfxYcIxobfmJ3nRxqBPEbDIGRxqLUAC+NUryxc0uKa3Uijo8JG4BL p147s8HfISRe1mM1/I0srz+A8MnFTFnjkxX+Nnr+6RNFMsBMRHBjWbIMudeURytBMXYX 9uS2rQu70/vmH0KpbsFlF1dCXKvqqQzGKHTmZRSHX7tdF03EnjSEAePyfoWhp/sdOnPG vWysMGbRhgyjgKuTVUH1Jx84WZ5heBj/f8VEnWphuDiZ3RmMRkn0P0b+++/UTuZMQCU5 T2TXt23phbbhXsutubXFA8nH53PaEY6w5sJBhbU0WTqZnbRUeuXxDCZ3OYlaeJ9+mslk qQWg== 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=GcUm6RLTEeD3KgJPy4/UddPSpkNsBUG2+AXODsI8Pv8=; b=EF5u0WzEyVlTjk4Ib9rHfkzAoPq9J2fK4nc4r+vcefiZBCvk6SXYwRv3dG26SQM7HS TtDPc/fZWrMrTTJ0rKIwQup8Fk/erCy9HQK8mVjhLp14TuDS8ZxQqxcMPzRfkvkRVSXO IvumUYICIZPZAz50Fi53LkMhYfnE3fQT37v9O+UiHR6NPwFPy9kmrbeDUYKjOBIo86Vb JDEfucg8U6KQplWSbignMUQ/soOMBfdnrfUJRZJZrrqK+a0OBShdEAqikfG5e0lC2jPq jJB/3luaEMeVztGOyzX/E6Up4Ca3cYpxAd95PCAe2zwxxunDZaOb0eV5qILuQ1ZbKVQd 5sAQ== X-Gm-Message-State: AOAM5339X3B0JKoLeDfXoHK/yY2+23c+IG5gKcwpePZbW+3bnRVEfl30 Q87WbTxSbuIYDD18ViJE+/ghvA== X-Google-Smtp-Source: ABdhPJwpR0f+Wbpme7NXrTmlL3bFmd5XbfjoyqGlA0xPHTDvSuDi+nhadVPEVemcToIAgVU96nIABw== X-Received: by 2002:a05:6638:538:: with SMTP id j24mr532827jar.59.1626974933674; Thu, 22 Jul 2021 10:28:53 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id x9sm17103176iol.2.2021.07.22.10.28.53 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 22 Jul 2021 10:28:53 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 56983800DAB; Thu, 22 Jul 2021 12:28:52 -0500 (CDT) Date: Thu, 22 Jul 2021 12:28:52 -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: <20210722172852.GJ19620@telsasoft.com> References: <784576.1626968702@sss.pgh.pa.us> <785218.1626969409@sss.pgh.pa.us> <20210722162254.GG19620@telsasoft.com> <20210722163556.GH19620@telsasoft.com> 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 05:26:26PM +0000, ldh@laurent-hasson.com wrote: > I tried this but not seeing max resident size data output. Oh. Apparently, that's not supported under windows.. #if defined(HAVE_GETRUSAGE) appendStringInfo(&str, "!\t%ld kB max resident size\n",