Opened 18 years ago

Last modified 17 years ago

#188 new defect

stats INT is too small

Reported by: dmorton Owned by: rjl
Priority: high Milestone: 1.1.0
Component: amavisd-maia Version: 1.0.0 RC6
Severity: normal Keywords:


It quite conceivable for size stats to exceed 2 GB in today's world. We need to change all INT's to BIGINT's.

Change History (3)

comment:1 Changed 18 years ago by rjl

The best way to solve the problem is ultimately to change the way averages are computed, i.e. a different algorithm. Right now we're storing the total size and the total count, and just dividing the total size by the total count to get the average. A better solution might store the total count and the average size itself, and not the total size at all (total size can always be obtained by multiplying total count by average size, after all).

comment:2 Changed 18 years ago by jleaver

  • Component changed from SQL scripts to amavisd-maia

I'm changing this to the amavisd-maia component, as that's where the proposed change must take place.

comment:3 Changed 17 years ago by dmorton

  • Milestone changed from 1.0.0 RC6 to 1.1.0

Database schema changes deferred to 1.1

Note: See TracTickets for help on using tickets.