Planet PostgreSQL – Hubert ‘depesz’ Lubaczewski: How much disk space you can save by using INT4/INT instead of INT8/BIGINT?

Lately there have been couple of discussions on IRC, Slack, and Reddit that showed that people assume that by using int4/integer they use 4 bytes less than they would in case of int8/bigint. This is not really the case. Let me explain why. First quick test. On my computer, which is running some Ryzen processor, … Continue reading “How much disk space you can save by using INT4/INT instead of INT8/BIGINT?”

External feed Read More at the Source: https://postgr.es/p/5fT