I have a table like the following
create table test {
id int8,
lastupdate date,
balance numeric(12, 2) };
With an index:
create index ix_test(id, lastupdate);
This table currently has 6 million records. I have done a vacuum full
and reindex this morning. The file associated with this table is 1g
on disk. This seems a lot high to me? Am I wrong, any help would be
greatly appreciated.
Thank You,
Bo Stewart