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 |
