Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDZZ1-0007HR-G1 for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Sep 2019 19:36:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iDZZ0-0007yv-Dt for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Sep 2019 19:36:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDZZ0-0007yn-5f for pgsql-hackers@lists.postgresql.org; Thu, 26 Sep 2019 19:36:30 +0000 Received: from mail-io1-xd41.google.com ([2607:f8b0:4864:20::d41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iDZYw-0001iv-QF for pgsql-hackers@postgresql.org; Thu, 26 Sep 2019 19:36:29 +0000 Received: by mail-io1-xd41.google.com with SMTP id a1so9676206ioc.6 for ; Thu, 26 Sep 2019 12:36:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=Kx4TmnHWdqFw770UQgHxwtKDZNPuS+GA8g3sF7i8qv0=; b=rryMExfuwdmlGn5gY6gHphTGQ1KnRAS8noOkAdYPn+XrrQupVxs0J5KLgkQUgwC7m1 oGFfA/o53fmsSN8VsFj6mn6tWdDeRZI7yY6HcCQ+evk1KtxV5lhaWG8H4cla+U8aP2Fz 8XQ0f9yRKeq7NeXLMYOtoztofPaMm3lN03atG3xIrs0rAGEGZxD2X2IzNmU5L4JqNDpc bPVyuGdlIluSKPO8Y4PXHow/ZhI9i//t3nVrPULYgMhQ/u852DC/Rse550PMWjidWTze kkRVE1yHbnEjVrHc6tIkM8eWU7V06R2iXPU5y7AnDQ1KgiAYxRvVIrYo2AbvhI3fUKUM FC1A== 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:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=Kx4TmnHWdqFw770UQgHxwtKDZNPuS+GA8g3sF7i8qv0=; b=pe5b9199SGDxOb0YhMOEFAZ/QxF8SQixWJ5wYZmfDWD0EpumI6IWMjce8RDCFrl6iH gXSHPVAD23yNA4za06CKxLiJxJEx4QQNkynvGJuLFQRIBip5K/7QM2HbS9JLJQhHSCrx jr4FmGhFtOHGdpJPNZdt2V0RGZjeOskhgZTptv15e49/yyAmV2KxfrvyZrL7rCLwZ9EX qRX0V2tYQlJiT7/7Mc3wACxLgr8/sFaKbbNI5/2ZXP2iq/jOfZhyZWmFi3naGX8XOc3B ANJ2pwBwgplYWGh5JBJ1l3Au81/1z/TzP2sf2t7MPEJfbzOgnj8rFPMjLNA7uImJCa8C tOwg== X-Gm-Message-State: APjAAAVD92dXb8tNwB8CZafJR3yHNeePttTClLq6WxMig0vG73erIvUJ gIXDJcHEvS3vw6lBdIMLJT7h+g== X-Google-Smtp-Source: APXvYqzhp8w0uLgreE3fpNbYSHteja5gUAUm3jQrxUjbfYX0TZ57sWuqcxqS1mK3cBsT67YJAW2bfg== X-Received: by 2002:a92:358e:: with SMTP id c14mr324156ilf.268.1569526585090; Thu, 26 Sep 2019 12:36:25 -0700 (PDT) Received: from nimloth.alvh.no-ip.org ([199.229.249.165]) by smtp.gmail.com with ESMTPSA id t18sm114923ilm.51.2019.09.26.12.36.24 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 26 Sep 2019 12:36:24 -0700 (PDT) Received: by nimloth.alvh.no-ip.org (Postfix, from userid 1000) id A4D84120349; Thu, 26 Sep 2019 16:36:20 -0300 (-03) Date: Thu, 26 Sep 2019 16:36:20 -0300 From: Alvaro Herrera To: Tomas Vondra Cc: Amit Kapila , PostgreSQL Hackers Subject: Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Message-ID: <20190926193620.GA16836@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20190926193359.GA16585@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2019-Sep-26, Alvaro Herrera wrote: > How certain are you about the approach to measure memory used by a > reorderbuffer transaction ... does it not cause a measurable performance > drop? I wonder if it would make more sense to use a separate contexts > per transaction and use context-level accounting (per the patch Jeff > Davis posted elsewhere for hash joins ... though I see now that that > only works fot aset.c, not other memcxt implementations), or something > like that. Oh, I just noticed that that patch was posted separately in its own thread, and that that improved version does include support for other memory context implementations. Excellent. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services