Re: BUG #2168: 45.000.000 records too much?

Some additional info. We repeated the test on different hardware with
unfortunately the same result. This is the output of the postgresql
logfile of that experiment:

LOG:  background writer process (PID 8208) was terminated by signal 9
LOG:  terminating any other active server processes
LOG:  statistics collector process (PID 8209) was terminated by signal 9
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2006-01-18 11:25:34 CET
LOG:  checkpoint record is at 3/AE5CF484
LOG:  redo record is at 3/AE5CB388; undo record is at 0/0; shutdown FALSE
LOG:  next transaction ID: 10061; next OID: 25648
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  redo starts at 3/AE5CB388
LOG:  record with zero length at 3/AE5E7314
LOG:  redo done at 3/AE5E72D0
LOG:  database system is ready

This time we tested with postgresql 8.0.3 on a 2.6.12 linux kernel.
(Previously i tested with postgresql 7.4.9 on a 2.6.15 kernel.)

I think you will be able to repeat the experiment with this information.


Regards,

Steven