Re: Does aurora PostgreSQL use wal_buffers?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



If memory serves, WAL is used for data streams if enabled.  Replication is done at storage layer within region.  Specific question can be sent to SA or Product team through your account representative.

From: https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-parameters-part-1-memory-and-query-plan-management/

"

wal_buffers

WAL buffers are used to hold write ahead log (WAL) records that aren’t yet written to storage. The size of the WAL buffer cache is controlled by the wal_buffers setting. Aurora uses a log-based storage engine and changes are sent to storage nodes for persistence. Given the difference in how writes are handled by the Aurora storage engine, this parameter should be left unchanged when using Aurora PostgreSQL.

"


Additional information con changes and architecture can be found in this talk: https://m.youtube.com/watch?v=Ul-j5fKfv2k

Generally, the slides for re:Invent talks make it on to https://www.slideshare.net/ as well.


Best regards,

Dan Smith


On Sun, Feb 6, 2022, 09:44 Goti <aryan.goti@xxxxxxxxx> 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@xxxxxxxxx> 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.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux