"HT" <htlevine(at)ebates(dot)com> writes:
> $ ls -l 3828262123*
> -rw------- 1 postgres postgres 1073741824 Dec 18 23:08 3828262123
> -rw------- 1 postgres postgres 558899200 Dec 18 23:16 3828262123.1
Okay, that looks more plausible.
I think you need a VACUUM FULL to recover the wasted space in the master
table, followed by more frequent plain VACUUMs to keep it from bloating.
It's also almost certain that you need to increase the FSM parameters in
postgresql.conf. See recent discussions in the archives about sizing
FSM properly.
regards, tom lane