Feng Chen wrote: > We also have the same exact problem - every 5 to 10 days when the data > get to some size, PostgreSQL complains about missing pg_clog files, and > invalid page headers during either vacuum or reindex operations. > > The problem happens on different customer sites with Linux 2.6.11. > > There is one particular table that is much more heavily used - 99% > inserts, some selects. And this table turns to be the one having > problems. > > If this happens at different companies so frequently, I'd doubt it's a > hardware problem. And we did check the hardware but did not find any > problems. > [...] > 2007-08-13T10:12:07+00:00 ERROR: invalid page header in block 4018 of > relation "calllegstart_sessionid" > 2007-08-13T10:12:15+00:00 ERROR: could not access status of > transaction 0 > 2007-08-13T10:12:15+00:00 DETAIL: could not create file > "pg_subtrans/0201": File exists
what version of postgresql is this exactly ? there is a problem in older 8.1 versions that could cause this error under high transaction rates. Stefan ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend