Use of integer instead of interval (of one type)
3
votes
1
answer
1266
views
Our DB design presently has a
interval
column which will only be storing days (no other interval type) so it is making sense to use INT2
(smallint
) instead of interval
. Reference to documentation.
Advantage: 2 bytes instead of 12 bytes (we have many such columns).
Is this line of thinking ok or am I overlooking something?
Asked by vedic
(180 rep)
Mar 8, 2014, 07:28 AM
Last activity: Feb 3, 2023, 05:17 PM
Last activity: Feb 3, 2023, 05:17 PM