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

AWS RDS PostgreSQL CPU Spiking to 100%

2020-09-08 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 spiking due to Bitm