On top of what Vivek said, you need to update your pg install. 7.4.2
had a few data eating bugs if I remember correctly. 7.4 branch is up
to 7.4.18, and those are a lot of bug fixes (2+ years) you're missing.
If one of those bugs eats your data, don't expect any sympathy.
In response to
pgsql-performance by date
|Next:||From: Peter Koczan||Date: 2007-09-28 17:33:35|
|Subject: Re: sequence query performance issues|
|Previous:||From: Vivek Khera||Date: 2007-09-28 14:53:20|
|Subject: Re: Postgres 7.4.2 hanging when vacuum full is run|