On Friday 20 June 2008 05:26, Robert Treat wrote: > On Thursday 19 June 2008 14:06:38 Garry Saddington wrote: > > > In any case, however, if PostgreSQL reported the transaction complete > > > and the machine didn't experience any hardware problems (like sudden > > > power or disk failure), I would certainly not suspect PostgreSQL as the > > > source of the problem. > > > > What has happened to the reports then? I have used this combination of > > Zope and Postgres for 5 years with no problems like this before and we > > have written one complete set of reports on this server in the past 6 > > weeks. The problem seems to have started last friday, when reports > > started to go missing. > > Out of curiosity, what is your vacuum strategy? We back up and vacuum at the same time each day. garry