pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedChanges in Aurora PostgreSQL for min & max_wal_size parameter
5+ messages / 3 participants
[nested] [flat]
* Changes in Aurora PostgreSQL for min & max_wal_size parameter
@ 2021-02-02 13:01 dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: dbatoCloud Solution @ 2021-02-02 13:01 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter
@ 2021-02-02 13:04 Scott Ribe <scott_ribe@elevated-dev.com>
parent: dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Scott Ribe @ 2021-02-02 13:04 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; +Cc: pgsql-admin
> On Feb 2, 2021, at 6:01 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
>
> when I checked with AWs they are saying that we cannot increase the max_wal_size & min_wal_size
Seems like you already have your answer.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter
@ 2021-02-02 13:06 John Scalia <jayknowsunix@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 1 reply; 5+ messages in thread
From: John Scalia @ 2021-02-02 13:06 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: dbatoCloud Solution <dbatocloud17@gmail.com>; pgsql-admin
With AWS Aurora, you’re out of luck. They really don’t allow many parameters and database parameter groups are not editable to add a new parameter. I deal with this on a daily basis.
Sent from my iPad
> On Feb 2, 2021, at 8:05 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>
>
>>
>> On Feb 2, 2021, at 6:01 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
>>
>> when I checked with AWs they are saying that we cannot increase the max_wal_size & min_wal_size
>
> Seems like you already have your answer.
>
>
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter
@ 2021-02-02 13:32 dbatoCloud Solution <dbatocloud17@gmail.com>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: dbatoCloud Solution @ 2021-02-02 13:32 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; pgsql-admin
Oh my God ! It is my time too. I am requesting them to share Dataware
house specific document to optimize Aurora PostgreSQL . This is the first
time I am working with this flavor earlier i used to work
community version. I don't know what to do now.
---------------------------------------------------------------------------------------------------------------------
Ashokkumar Mani *(OCP12c/11g/10g/9i, AWS SAA, M103)*
*Dubai** , UAE* *| BLR , INDIA*
M: *+971 54 723 0075 *| *+91 90086 70302 | *WApp :* +91 81975 99922*
W: https://dbatocloudsolution.blogspot.in/
<http://dbatocloudsolution.blogspot.in/; | E: dbatocloud17@gmail.com
On Tue, Feb 2, 2021 at 6:36 PM John Scalia <jayknowsunix@gmail.com> wrote:
> With AWS Aurora, you’re out of luck. They really don’t allow many
> parameters and database parameter groups are not editable to add a new
> parameter. I deal with this on a daily basis.
>
> Sent from my iPad
>
> > On Feb 2, 2021, at 8:05 AM, Scott Ribe <scott_ribe@elevated-dev.com>
> wrote:
> >
> >
> >>
> >> On Feb 2, 2021, at 6:01 AM, dbatoCloud Solution <dbatocloud17@gmail.com>
> wrote:
> >>
> >> when I checked with AWs they are saying that we cannot increase the
> max_wal_size & min_wal_size
> >
> > Seems like you already have your answer.
> >
> >
> >
> >
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Changes in Aurora PostgreSQL for min & max_wal_size parameter
@ 2021-02-02 13:43 John Scalia <jayknowsunix@gmail.com>
parent: dbatoCloud Solution <dbatocloud17@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: John Scalia @ 2021-02-02 13:43 UTC (permalink / raw)
To: dbatoCloud Solution <dbatocloud17@gmail.com>; +Cc: pgsql-admin
Well, I hate to be bearer of bad news, but Aurora PostgreSQL is certainly not the community version, and they really haven”t built it for data warehousing.
Sent from my iPad
> On Feb 2, 2021, at 8:32 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
>
>
> Oh my God ! It is my time too. I am requesting them to share Dataware house specific document to optimize Aurora PostgreSQL . This is the first time I am working with this flavor earlier i used to work community version. I don't know what to do now.
>
>
>
> ---------------------------------------------------------------------------------------------------------------------
>
> Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103)
>
> Dubai , UAE | BLR , INDIA
>
> M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922
>
> W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com
>
>
>
>> On Tue, Feb 2, 2021 at 6:36 PM John Scalia <jayknowsunix@gmail.com> wrote:
>> With AWS Aurora, you’re out of luck. They really don’t allow many parameters and database parameter groups are not editable to add a new parameter. I deal with this on a daily basis.
>>
>> Sent from my iPad
>>
>> > On Feb 2, 2021, at 8:05 AM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>> >
>> >
>> >>
>> >> On Feb 2, 2021, at 6:01 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
>> >>
>> >> when I checked with AWs they are saying that we cannot increase the max_wal_size & min_wal_size
>> >
>> > Seems like you already have your answer.
>> >
>> >
>> >
>> >
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2021-02-02 13:43 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-02-02 13:01 Changes in Aurora PostgreSQL for min & max_wal_size parameter dbatoCloud Solution <dbatocloud17@gmail.com>
2021-02-02 13:04 ` Scott Ribe <scott_ribe@elevated-dev.com>
2021-02-02 13:06 ` John Scalia <jayknowsunix@gmail.com>
2021-02-02 13:32 ` dbatoCloud Solution <dbatocloud17@gmail.com>
2021-02-02 13:43 ` John Scalia <jayknowsunix@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox