| From: | Björn Metzdorf <bm(at)turtle-entertainment(dot)de> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Uninitialized page - fixing |
| Date: | 2003-06-07 21:56:49 |
| Message-ID: | 004d01c32d3f$b4972620$0564a8c0@shock |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
this is a repost, first one didn't pass moderator ?!
---
Hi,
recently we are suffering from repeated
WARNING: Rel pg_toast_77798203: Uninitialized page 25489 - fixing
entries in the logfile.
We had this problem 2 weeks ago (especially on some read often write often
tables, which are often vacuumed), along with some more severe problems
(pg_clog not found etc..). We
assumed hardware failure and moved to another box. It all went fine for 1
week, but now those uninitialized page messages come up again.
Our system is a dual p3 1 ghz, 2gb ram, Debian woody, kernel 2.4.20,
postgresql 7.3.2, database size is about 2 gb.
These problems seem to occur under heavy load only. We vacuum regularly
(every 5-15 minutes).
If you need any more details please say so.
tia
Regards,
Bjoern
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eko Pranoto | 2003-06-08 10:34:28 | DUMPall PG7.1.3 restore to PG7.3.2 |
| Previous Message | Mendola Gaetano | 2003-06-07 18:02:41 | Re: Help! Error when calling a function |