Re: AWS RDS PostgreSQL CPU Spiking to 100%

2020-09-30 Thread aditya desai
Thanks, I'll check it out. On Mon, Sep 28, 2020 at 9:40 PM Prince Pathria wrote: > We faced a similar issue, adding RDS proxy in front of RDS Postgres can > help. > In our situation, there were a lot of connects/disconnects from Lambda > functions although concurrency of Lambda was 100 only. > A

Re: AWS RDS PostgreSQL CPU Spiking to 100%

2020-09-28 Thread Prince Pathria
We faced a similar issue, adding RDS proxy in front of RDS Postgres can help. In our situation, there were a lot of connects/disconnects from Lambda functions although concurrency of Lambda was 100 only. And adding connection pooler(RDS proxy) helped us to reduce the CPU load from 100% to 30% Happ

Re: AWS RDS PostgreSQL CPU Spiking to 100%

2020-09-28 Thread aditya desai
> > > Hi, > We have an application where one of the APIs calling queries(attached) is > spiking the CPU to 100% during load testing. > However, queries are making use of indexes(Bitmap Index and Bitmap Heap > scan though). When run separately on DB queries hardly take less than 200 > ms. Is CPU spi

Re: AWS RDS PostgreSQL CPU Spiking to 100%

2020-09-08 Thread Jeff Janes
On Tue, Sep 8, 2020 at 9:33 AM aditya desai wrote: > Hi, > We have an application where one of the APIs calling queries(attached) is > spiking the CPU to 100% during load testing. > However, queries are making use of indexes(Bitmap Index and Bitmap Heap > scan though). > The CPU is there to be u

Re: AWS RDS PostgreSQL CPU Spiking to 100%

2020-09-08 Thread Pavel Stehule
Ășt 8. 9. 2020 v 15:33 odesĂ­latel aditya desai napsal: > Hi, > We have an application where one of the APIs calling queries(attached) is > spiking the CPU to 100% during load testing. > However, queries are making use of indexes(Bitmap Index and Bitmap Heap > scan though). When run separately on D