VCS with PostgreSQL should use UUID type for doc id field instead of varchar(36)
--------------------------------------------------------------------------------
Key: NXP-4803
URL: https://jira.nuxeo.org/browse/NXP-4803
Project: Nuxeo Enterprise Platform
Issue Type: Improvement
Components: Core SQL Storage
Affects Versions: 5.3 GA
Environment: PostgreSQL
Reporter: Benoit Delbosc
The size of the uuid field is 40% smaller on disk, the size of the btree index
is 50% smaller.
For instance a column of varchar(36) with a btree index on 1m lines takes 134
MB:
* 72 MB of data
* 62MB of index
While the same value using uuid takes 80 MB :
* 46 MB of data
* 33 MB of index
This reduce the memory footprint of the database. Furthermore having numeric
value and smaller index should be more efficient.
This should be used as the default for new instance, the code should keep
backward compatibility with doc id stored as varchar(36).
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
