Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0030659 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | minor | have not tried | 2015-08-25 08:55 | 2019-02-14 07:53 | |||||||
| Reporter | AugustoMauch | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0030659: Improve the generation of UUIDs so that they can be indexed more efficiently | |||||||||||
| Description | Openbravo uses the uuid_generate_v4 [1] function to generate UUIDs with PostgreSQL. The function generates randomized UUIDs that are very scattered, which is makes the updates of the indexes based on these UUIDs very slow. The index updates could potentially be much more efficient if the UUIDs were more grouped [1] http://www.postgresql.org/docs/9.4/static/uuid-ossp.html [^] | |||||||||||
| Steps To Reproduce | - | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0109817) pramodkumar (developer) 2019-02-14 07:53 |
The Postgres write load managing optimization way suggested by partner[0007725] https://www.youtube.com/watch?v=xrMbzHdPLKM [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-08-25 08:55 | AugustoMauch | New Issue | |
| 2015-08-25 08:55 | AugustoMauch | Assigned To | => AugustoMauch |
| 2015-08-25 08:55 | AugustoMauch | Modules | => Core |
| 2015-08-25 08:55 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2015-08-25 09:00 | AugustoMauch | Description Updated | View Revisions |
| 2019-02-14 07:53 | pramodkumar | Note Added: 0109817 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |