I have 2 identical tables for 2 countries: ES and NL. In
table_es I have 477k rows, in
table_nl 1.600M rows, but after checking size of both tables I have 26 GB in ES and 24 GB in NL.
How is it possible that
table_es is using that amount of space?
In both tables indexes are only on primary keys. Database encoding is UTF-8. I sum length of the text fields in both tables and for example description in
table_es takes 0.5 GB (477k rows) and 3.99 GB for
table_nl (1.600M rows) which is what I am expecting.
I checked the amount of dead_tuples in both tables, but for both is 0. Autovacuum is on.
Everyday during the night 50 - 500k rows are deleted from both tables and similar amount for rows are inserted.
Does somebody have an idea what is going on?