Postgres Table Size - Mailing list pgsql-admin

From stewarrb@yahoo.com (Bo Stewart)
Subject Postgres Table Size
Date
Msg-id 9a41d107.0310310955.2c5432ef@posting.google.com
Whole thread Raw
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error compiling 7.3.4 on Solaris 9
Next
From: "scott.marlowe"
Date:
Subject: Re: performance problem - 10.000 databases