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 1lmjEt-0007sP-BC for pgsql-performance@arkaria.postgresql.org; Fri, 28 May 2021 20:37:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lmjEs-0004J7-8q for pgsql-performance@arkaria.postgresql.org; Fri, 28 May 2021 20:37:50 +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 1lmjEs-0004Iz-0W for pgsql-performance@lists.postgresql.org; Fri, 28 May 2021 20:37:50 +0000 Received: from aws.mailpen.com ([52.43.43.172] helo=aws2.mailpen.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lmjEo-0002UV-Sc for pgsql-performance@lists.postgresql.org; Fri, 28 May 2021 20:37:49 +0000 Received: from [172.20.70.208] (unknown [50.35.114.95]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by aws2.mailpen.com (Postfix) with ESMTPSA id D0045C54065 for ; Fri, 28 May 2021 13:37:41 -0700 (PDT) Subject: Re: AWS forcing PG upgrade from v9.6 a disaster To: "pgsql-performance@lists.postgresql.org" References: <88dec70b-eb63-0b72-0b5d-253851ef127b@mailpen.com> <9fa75894-d3be-e40b-cd89-f641bdf85df0@dunslane.net> From: "Dean Gibson (DB Administrator)" Organization: UltiMeth Systems Message-ID: <03071c81-aaad-f5ea-7a78-a4acb87960fd@mailpen.com> Date: Fri, 28 May 2021 13:37:41 -0700 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Thunderbird/78.10.2 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------CE8BEF94B1470E8F2264A338" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------CE8BEF94B1470E8F2264A338 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit On 2021-05-28 12:18, Campbell, Lance wrote: > > Also, did you check your RDS setting in AWS after upgrading? I run > four databases in AWS. I found that the work_mem was set way low > after an upgrade. I had to tweak many of my settings. > > Lance > > I've wondered a lot about work_mem. The default setting (which I've tried) involves a formula, so I have no idea what the actual value is. Since I have a db.t2.micro (now db.t3.micro) instance with only 1GB of RAM, I've tried a value of 8000. No difference. --------------CE8BEF94B1470E8F2264A338 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit

On 2021-05-28 12:18, Campbell, Lance wrote:

Also, did you check your RDS setting in AWS after upgrading? I run four databases in AWS. I found that the work_mem was set way low after an upgrade. I had to tweak many of my settings.

Lance

I've wondered a lot about work_mem. The default setting (which I've tried) involves a formula, so I have no idea what the actual value is. Since I have a db.t2.micro (now db.t3.micro) instance with only 1GB of RAM, I've tried a value of 8000. No difference.

--------------CE8BEF94B1470E8F2264A338--