Fabrice, I think we planned for regular 4 byte int for chunkid. But check with others from the group, I am way too busy with the overall dm type things right now... On 02/18/2016 09:45 AM, Fabrice Jammes wrote: > Sorry for nitpicking, but it seems that 8 bytes (a SMALLINT for chunkID > and a BIGINT for objectId) would be enough to store one raw: > http://dev.mysql.com/doc/refman/5.5/en/integer-types.html > > This would lead to an index of: > 38 * 10^9 objects * (2+8 bytes) = 380 GB > > And, with overhead, 1.2TB. > > Can I send these number to Fabio please? > > Cheers, ######################################################################## Use REPLY-ALL to reply to list To unsubscribe from the QSERV-L list, click the following link: https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1