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 1pmee0-00084X-6W for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Apr 2023 17:52:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pmedz-0004w5-1w for pgsql-bugs@arkaria.postgresql.org; Wed, 12 Apr 2023 17:52:31 +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 1pmedy-0004vw-Ld for pgsql-bugs@lists.postgresql.org; Wed, 12 Apr 2023 17:52:30 +0000 Received: from mail-io1-xd30.google.com ([2607:f8b0:4864:20::d30]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pmedw-0003Ba-6y for pgsql-bugs@lists.postgresql.org; Wed, 12 Apr 2023 17:52:29 +0000 Received: by mail-io1-xd30.google.com with SMTP id d186so4910134iog.12 for ; Wed, 12 Apr 2023 10:52:28 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; t=1681321947; x=1683913947; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=Tz7G4gTDQ/E4Y7q4VSpWouPpqL+ezveXPOEBPycP7HM=; b=0jBOQXgMZgJ/yUYFk/XnoAqta/TiSbwu3Kd+WwhXrEYxx5xBIviFU2G7RAAfEafjSR odip/r7X9IIrDzac27JLk8l8Paml3rhJI5iCL/FRW01GWrurwyB7pVJ5XK5pba/w/pX7 ks3HhBhNx5pIzilGT3+5WigebyBOSn7HkxR6CfSBRqDBIJ0XfO33e8lRaFKeZ9J3gjTL RNHbOWUg91QqCY3bzTAbfuPFhXxjhxxrw7T7JWvKxdXB621z387qnr80VhtJf7UPKzNe wS0OmUf9qabU3PsXmEvYiEvqF4fXaMtedjzlpo1LNeqN/NLEmrOl0ucjWhP5Dfgp5o/n /0eQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681321947; x=1683913947; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=Tz7G4gTDQ/E4Y7q4VSpWouPpqL+ezveXPOEBPycP7HM=; b=CTfzrWBLDLD1KaM2PxGTDThLADOGZt2bKUgzU1weuIxcYSIafsc78i4hv2dv6dhRJO 3Oom5delbVdHma5/JMbIGHn2EPzoc21qCC3g8DwNKX5FRT5MXWNSYXjHH1IdaOT8ps0U XMwf5Zwc9xvaQyrAHSdLC+TWoXiYl/yjZpNNmLvyTbo8g6pIPhTIujUUqug+PJ+xNB6u IsJ7OcW7Hv827Eeq66UUGjGPx+2TR+ryNkEfdvuyn7kja4K9iAiHDBFUZXBEueAAWBRK CnmXiPTfsAcY/A+cCmoiIGthmoTLvaZHpT1nsy9LDnbYfw7Ne9EvCcX6luzQQi8UlUs/ tHdA== X-Gm-Message-State: AAQBX9dDutUs5IuymTX8ttp//NmwtzS3ZJXTFPMzMWeS+aCFAEcHPoRE 1uX8asn4D3LbXmxYzrJs3ssz/A== X-Google-Smtp-Source: AKy350bs5sROOoqGdMnLMNXp8YxvGr2HcOYNdonKjHoccX5cIUjn3qDhYNgJMXBrcQk7QCz6rNev6w== X-Received: by 2002:a6b:f306:0:b0:758:6728:7023 with SMTP id m6-20020a6bf306000000b0075867287023mr12836181ioh.21.1681321947593; Wed, 12 Apr 2023 10:52:27 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id h23-20020a5d80d7000000b0071664d0a4d7sm4660993ior.49.2023.04.12.10.52.26 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 12 Apr 2023 10:52:27 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id C1634801C24; Wed, 12 Apr 2023 12:52:25 -0500 (CDT) Date: Wed, 12 Apr 2023 12:52:25 -0500 From: Justin Pryzby To: Andres Freund Cc: Heikki Linnakangas , Duncan Sands , pgsql-bugs@lists.postgresql.org Subject: Re: Unlimited memory consumption with long-lived connection Message-ID: References: <7484b4bd-a808-ed9e-892c-933f7f24120f@iki.fi> <20230222145341.GT1653@telsasoft.com> <20230222182811.n6n7bvzc3kd3n6f3@awork3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230222182811.n6n7bvzc3kd3n6f3@awork3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Feb 22, 2023 at 10:28:11AM -0800, Andres Freund wrote: > I'd feel a lot better applying the patch if there'd be a bit more review. If > none is forthcoming, I'm somewhat inclined to just apply it to HEAD and later > decide whether we'd want to backpatch. Previously I ran the patches in production. Not sure what else I could do, but it seems important to do something. -- Justin