Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2015-08-25 08:552019-02-14 07:53
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0030659: Improve the generation of UUIDs so that they can be indexed more efficiently

DescriptionOpenbravo 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] [^]
Steps To Reproduce-
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
pramodkumar (developer)
2019-02-14 07:53

The Postgres write load managing optimization way suggested by partner[0007725] [^]

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker