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 1kXKYE-0003QS-5p for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Oct 2020 08:41:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kXKYD-0003Bo-3u for pgsql-bugs@arkaria.postgresql.org; Tue, 27 Oct 2020 08:41:53 +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 1kXKYC-0003Bg-Rt for pgsql-bugs@lists.postgresql.org; Tue, 27 Oct 2020 08:41:52 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kXKY5-0006oX-SO for pgsql-bugs@lists.postgresql.org; Tue, 27 Oct 2020 08:41:51 +0000 Received: from [192.168.27.200] (unknown [93.174.131.141]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 88E9421C1C39; Tue, 27 Oct 2020 11:41:43 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1603788103; bh=SofY3c/tpw+TXrogZQDQfwn0RR8xk4V6ozWfG+FKkiY=; h=Subject:To:Cc:References:From:Date:In-Reply-To; b=fb2KUvdaYH6DGIyYTH16oAlenlb3wucp0ERxg7NKdCgAygN34ImmiD+Rb/7fwZEwn d+T6tTg4LzHSDLxAKLJEFCZC9DIx1FDT932oZ7gvjqq4/nLNBWS3nW/cafaPD06/17 zizHOvc7hFdFq11c9WaIH+2VXivsfDo7NgwrkaAc= Subject: Re: Memory leak in RelationBuildRowSecurity To: Tom Lane Cc: pgsql-bugs@lists.postgresql.org References: <21356c12-8917-8249-b35f-1c447231922b@postgrespro.ru> <1852787.1601041699@sss.pgh.pa.us> <3f670fa6-5e81-fbd9-b880-eaa275f15e1c@postgrespro.ru> <1937613.1601057234@sss.pgh.pa.us> <2029358.1601139941@sss.pgh.pa.us> From: Konstantin Knizhnik Message-ID: Date: Tue, 27 Oct 2020 11:41:43 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1 MIME-Version: 1.0 In-Reply-To: <2029358.1601139941@sss.pgh.pa.us> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 26.09.2020 20:05, Tom Lane wrote: > Konstantin Knizhnik writes: >> On 25.09.2020 21:07, Tom Lane wrote: >>> This is against HEAD but I think it wouldn't be hard to back-patch. >>> Are you in a position to see if it fixes the problem in your customer's >>> environment? >> Thank you. >> Your patch fixes the problem. > Thanks for testing! I'll try to get this committed later today. > > regards, tom lane Just want to convey gratitude from the customer: after apply your patch memory consumption is decreased 3 times which significantly improves performance of their system. -- Konstantin Knizhnik Postgres Professional: http://www.postgrespro.com The Russian Postgres Company