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 1nGjM4-0008Tu-6Q for pgsql-admin@arkaria.postgresql.org; Sun, 06 Feb 2022 15:21: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 1nGjM2-0002cn-4j for pgsql-admin@arkaria.postgresql.org; Sun, 06 Feb 2022 15:21:30 +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 1nGjM1-0002ce-Mz for pgsql-admin@lists.postgresql.org; Sun, 06 Feb 2022 15:21:29 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nGjLz-0006CV-Al for pgsql-admin@lists.postgresql.org; Sun, 06 Feb 2022 15:21:28 +0000 Received: by mail-ot1-x332.google.com with SMTP id n6-20020a9d6f06000000b005a0750019a7so9273928otq.5 for ; Sun, 06 Feb 2022 07:21:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=T2UOJ6O8m2jxYo7yCi52g5P7fAoukK4pqWa3fIdanaw=; b=F6heQWBzEgvscTvXGQdnHt/BMsipWAzAg/D2id3+SVzPSOdWuCCh9lrsAwuRI8gWFO dTiYsC5Z544QAwsFDPTr+4nO/3PiEaKBvnyOVs0ZP+LaXqDM/fdq1wsTIooSjhT4mtpx 3323j45yyoQZjAjITz+0gjTc6ZpbRDEPYIUle1OFm3qEhl1pBtJWPdVYZhBPjVPeFZay rGBlKENrlGzTqh8FQhrQWi+Zxhf9sR/bp9ThEnL2jJPKyiow780SfUshARATBvwh1uK7 oEquU0gxmrizPS7M14huvJgf7rAd3SQPH7rQ6bocZB4tFPJr+bfRvBRt6hvqhAQmNJYd EpVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=T2UOJ6O8m2jxYo7yCi52g5P7fAoukK4pqWa3fIdanaw=; b=ph4ryXaXa4FPvVU8mZLJl2Z5utOOFD8Q9C6NO9vloaItlu0V2Tg9wRAKQfuiSdmM13 uS5jHEEypSQEbcK2nAmm6HS0YrVbeyUFPenPePPqByd41u5yDmag1u+TmqBaSVzjvyKp G4R+ne4dmAHqJSGvL7Dietvy7OBuBNannycOi6bULveJ6DdngJQCArXWsx7h9bUZTa2W hHJQXFIRsW6v4KYt4wA9/UcL5e29C9+wk2AlhYDmPib0v+LoKH7FhOR8bkpBUBLra+iS z5pgpBUe9bDscS5jbBMQPcN1tYaoStkIyHzie2EoLGfFZYOMu6bpgd05owSi5FGSTY0G xVlw== X-Gm-Message-State: AOAM532oTe0AlQQt4/R53ItnjvgMeVWEq/ABr3Asw/dKtSv+EF5P2JDP xuS+cMpCAe3diRzW72WXPN+UVidYzyA= X-Google-Smtp-Source: ABdhPJza8sxY+nkuEOljAQpmI3qUJ6ZfFwu1ZLzHySzABV0VM8Kv8weYe2IpBKG19+G5oGDf4CncZA== X-Received: by 2002:a9d:6d8f:: with SMTP id x15mr2790118otp.23.1644160886219; Sun, 06 Feb 2022 07:21:26 -0800 (PST) Received: from [192.168.88.10] (ip68-11-68-85.no.no.cox.net. [68.11.68.85]) by smtp.googlemail.com with ESMTPSA id d7sm2902986otf.66.2022.02.06.07.21.25 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 06 Feb 2022 07:21:25 -0800 (PST) Subject: Re: Does aurora PostgreSQL use wal_buffers? To: pgsql-admin@lists.postgresql.org References: <20220206132509.4cmuhmonaxsmmg3o@jrouhaud> From: Ron Message-ID: <8b6df28a-7289-a449-9680-8fc06ad58dd0@gmail.com> Date: Sun, 6 Feb 2022 09:21:24 -0600 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.14.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------30CAA7F2EAA44B65A90A5A0B" 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. --------------30CAA7F2EAA44B65A90A5A0B Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit If you can't find it in the documentation, then dba.stackexchange would be the place to ask. On 2/6/22 7:43 AM, Goti wrote: > Sure Julien. I will ask Amazon too. My intention was just to gather this > info IN CASE if someone has already an idea on this. Does that mean that I > should not be posting Aurora postgres related questions/ doubts here? > Please correct me if I am wrong! > Thanks, > > Goti > > > On Sun, Feb 6, 2022 at 6:55 PM Julien Rouhaud > wrote: > > Hi, > > On Sun, Feb 06, 2022 at 05:24:37PM +0530, Goti wrote: > > > > Can someone shed some light as to whether aurora postgres uses wal > buffers > > or not? Given the way the writes are handled differently, I would > like to > > understand the same while it is being said in the documentation not to > > change the parameter from the default value of 16MB. > > It's unlikely that any one here can answer the question. You should > ask Amazon, > not us. > -- Angular momentum makes the world go 'round. --------------30CAA7F2EAA44B65A90A5A0B Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit If you can't find it in the documentation, then dba.stackexchange would be the place to ask.

On 2/6/22 7:43 AM, Goti wrote:
Sure Julien. I will ask Amazon too. My intention was just to gather this info IN CASE if someone has already an idea on this.  Does that mean that I should not be posting Aurora postgres related questions/ doubts here? Please correct me if I am wrong!
Thanks,

Goti


On Sun, Feb 6, 2022 at 6:55 PM Julien Rouhaud <rjuju123@gmail.com> wrote:
Hi,

On Sun, Feb 06, 2022 at 05:24:37PM +0530, Goti wrote:
>
> Can someone shed some light as to whether aurora postgres uses wal buffers
> or not? Given the way the writes are handled differently, I would like to
> understand the same while it is being said in the documentation not to
> change the parameter from the default value of 16MB.

It's unlikely that any one here can answer the question. You should ask Amazon,
not us.

--
Angular momentum makes the world go 'round.
--------------30CAA7F2EAA44B65A90A5A0B--