| From: | Björn Metzdorf <bm(at)turtle-entertainment(dot)de> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Uninitialized page - fixing |
| Date: | 2003-06-05 21:11:58 |
| Message-ID: | 015b01c32ba7$1c523bf0$0564a8c0@shock |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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), 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 | Vlad Efman | 2003-06-05 21:38:53 | unsubscribe |
| Previous Message | David A. Leedom | 2003-06-05 20:40:33 | Re: Backup and Restore |