Hey,
I’m a new user of PostgreSQL. I found one of my tables is taking unexpectedly large space:
select pg_size_pretty(pg_relation_size('archive_files'));
pg_size_pretty
----------------
1113 MB
The structure of this table is like:
Column | Type | Modifiers
------------+-------------------+-----------
archive_id | integer | not null
dir_no | integer | not null
fname | character varying | not null
type | smallint | not null
size | bigint | not null
mod_date | integer | not null
blocks | bigint | not null
blk_offset | bigint | not null
the field “fname” stores file names without any directory names. In our case, each record is expected to take around 300 bytes.
However, this table contains 934829 records, which means each record takes about 1.2KB.
I did vaccum, reindex, the size is still the same. Is there anything else that I can do?
Thanks!
John