Project:
| View Revisions: Issue #49617 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0049617: performance imporovement on the ad_session table | ||
| Revision | 2022-07-18 09:45 by egoitz | ||
| Steps To Reproduce | Having pg_stat_statements installed on the database of a customer with lot of concurrencies, we have taken some statistics about the information read. The result is that for the query on the ad-sesion table, many TB of disk are readed. The data read per execution is 788MB but as the query is executed many times, the accumulated data read is really high. To enable pg_stat_statemnts: http://wiki.openbravo.com/wiki/Finding_Perfomance_Issues#Tracking_SQL_Statements [^] |
||
| Revision | 2022-06-21 13:58 by shankarb | ||
| Steps To Reproduce | General speed in query results after adding the index in API calls. | ||
| Revision | 2022-06-21 13:43 by shankarb | ||
| Steps To Reproduce | General speed in query results after adding the index. | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |