[
https://jira.nuxeo.org/browse/NXP-4803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on NXP-4803 stopped by Benoit Delbosc.
> 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.1
> Environment: PostgreSQL
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
> Original Estimate: 2 days
> Remaining Estimate: 2 days
>
> 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
