Hi Justin,
You mean, So should I request for to increase the System Ram from 32 Gb to 64
Gb and keep the same parameter setting.Is it ?
Br,
Haseeb Ahmad
>
> On 10-Jun-2021, at 9:28 AM, Justin Pryzby wrote:
>
> On Thu, Jun 10, 2021 at 05:45:45AM +0500, Haseeb Khan wrote:
>> We have install
On Thu, Jun 10, 2021 at 05:45:45AM +0500, Haseeb Khan wrote:
> We have installed PostgreSQL V13 on window’s server 2016, where we kept the
> Ram of the Server is 32 GB and disk size is 270 GB.Later we faced some
> performance issues regarding the database, after deep dive into it we came up
> an
Having now successfully migrated from PostgreSQL v9.6 to v13.2 in Amazon
RDS, I wondered, why I am paying AWS for an RDS-based version, when I
was forced by their POLICY to go through the effort I did? I'm not one
of the crowd who thinks, "It works OK, so I don't update anything". I'm
usually
Hello Everyone,
I trust that everyone is Keep doing very Well !
We have installed PostgreSQL V13 on window’s server 2016, where we kept the Ram
of the Server is 32 GB and disk size is 270 GB.Later we faced some performance
issues regarding the database, after deep dive into it we came up and in
Below is the test setup
Jmeter-->(load balanced tomcat on ec2 instances)>rds read replicas
All these are running on different ec2 instances in AWS cloud in the same
region
On Tue, 8 Jun 2021, 19:03 Ayub Khan, wrote:
>
> I checked all the indexes are defined on the tables however the query
On Tue, Jun 8, 2021 at 12:32 PM Ayub Khan wrote:
> In AWS RDS performance insights the client writes is high and the api
> which receives data on the mobile side is slow during load test.
>
That indicates a client or network problem.
Jeff
@Magnus
There is an EC2 tomcat server which communicates to postgresql. This is a
replica of our production server except that in this case the test database
is postgres RDS and our production is running oracle on EC2 instance.
On Wed, Jun 9, 2021 at 5:47 PM Ayub Khan wrote:
> attached is the s
On Wed, Jun 9, 2021 at 4:47 PM Ayub Khan wrote:
>
> attached is the screenshot of RDS performance insights for AWS and it shows
> high waiting client writes. The api performance is slow. I read that this
> might be due to IOPS on RDS. However we have 80k IOPS on this test RDS.
>
ClientWrite mea
