I'd like to see a proposal on how to change the schema to do that.
So what fields can safely be changed from int8 to int4, what fields need extra precautions or even code changes, and what fields do warrant int8.


All INT8 can be changed into INT4 on small to middle installs. We have them all INT4 with 10K users.

On large installs for dbmail_physmessage.id, dbmail_messages.message_idnr:
These can be INT4 by creating code that can handle possible wrap around,
(if it wraps search for the next "free" value) or leave it at INT8 for now.

_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to