Changes in Aurora PostgreSQL for min & max_wal_size parameter - Mailing list pgsql-admin

From dbatoCloud Solution
Subject Changes in Aurora PostgreSQL for min & max_wal_size parameter
Date
Msg-id CAEz7P_vMe-b0yj+h2UNvFiJ-siLB7gO6Cf7uCT-F9bd=XpNyfQ@mail.gmail.com
Whole thread Raw
Responses Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Dear All,

We need your support for the below parameter changes. I want to increase/set these parameters in Aurora PostgreSQL when I checked with AWs they are saying that we cannot increase the max_wal_size & min_wal_size and there is no option and for another parameter, it can be done via a new parameter group.

 

 

 

Alter system set max_wal_size = '16384';

alter system set min_wal_size = '4096';

Alter system set effective_io_concurrency = '200';

Alter system set checkpoint_completion_target = '0.9';

 

Our environment into Dataware housing (analytic applications) where too many complex queries are used. I used pgtune (https://pgtune.leopard.in.ua/#/) for the calculation .

 

Kindly let me know is there way to increase the min_wal_size and max_wal_size .


Thanks and Best Wishes,

Ashok

+91 81975 99922 


pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: Re: could not write to log file: No space left on device -> AWS RDS Aurora postgreql DB
Next
From: Scott Ribe
Date:
Subject: Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter