Re: [PR] JAMES-2586 Add index for thread table [james-project]

[via GitHub]

vttranlina commented on PR #2528:
URL: https://github.com/apache/james-project/pull/2528#issuecomment-2505434214

   Gatling test result 
   
   **1. After**
   
   
![image](https://github.com/user-attachments/assets/3ade0b91-71ff-4616-b724-7ea57c5c2835)
   
   metrics
   ```
   # TYPE postgres_execution summary
   postgres_execution{quantile="0.5",} 0.0017612790000000001
   postgres_execution{quantile="0.75",} 0.0025886710000000003
   postgres_execution{quantile="0.95",} 0.006193151
   postgres_execution{quantile="0.98",} 0.009830399
   postgres_execution{quantile="0.99",} 0.014155775
   postgres_execution{quantile="0.999",} 0.035127295
   postgres_execution_count 2472972.0
   ```
   
![image](https://github.com/user-attachments/assets/0a4d239b-7d98-480c-8761-e660a9f8a62e)
   
   
   **2. Before**
   Result of 26/11
   
![image](https://github.com/user-attachments/assets/5f99777a-9754-4eab-9e09-0244652aa785)
   
   metrics
   ```
   # TYPE postgres_execution summary
   postgres_execution{quantile="0.5",} 0.001622015
   postgres_execution{quantile="0.75",} 0.0028016630000000002
   postgres_execution{quantile="0.95",} 0.021495807000000002
   postgres_execution{quantile="0.98",} 0.07864319900000001
   postgres_execution{quantile="0.99",} 0.149946367
   postgres_execution{quantile="0.999",} 0.599785471
   postgres_execution_count 3355670.0
   ```
   
![image](https://github.com/user-attachments/assets/05fe8db5-0e50-40e7-8fbd-1d975cbbd467)
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscr...@james.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@james.apache.org
For additional commands, e-mail: notifications-h...@james.apache.org