Re: AWS RDS PostgreSQL CPU Spiking to 100%

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%

ú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%

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

Re: Query Performance in bundled requests

On Tue, Sep 08, 2020 at 10:30:50AM +, Dirk Krautschick wrote: > Update: Better title and format corrections > > Hi %, > > in order to be able to readjust the effects of the stored procedure and, if > necessary, to save turnaround times, different requests can be concatenated > using semicol

Query Performance in bundled requests

Update: Better title and format corrections Hi %, in order to be able to readjust the effects of the stored procedure and, if necessary, to save turnaround times, different requests can be concatenated using semicolons for bundling several statements in one request. We did some tests against a

AW: Query performance issue

Hi %, in order to be able to readjust the effects of the stored procedure and, if necessary, to save turnaround times, different requests can be concatenated using semicolons for bundling several statements in one request. We did some tests against a postgres cluster. The results in terms of