Hi all,

I have few of these messages in server log:

ERROR:  out of memory
DETAIL:  Failed on request of size 262143996.
STATEMENT:  VACUUM ANALYZE tablename

There are few of them, always the same request size(?) but different two databases (out of 100+) and few different tables (pg_listener, pg_statistic and few slony tables). Vacumm analyze is issued by pg_autovacuum.

We're also seeing strange behavior of listen/notify in possibly corrupted database: there are notify events being received by listen process which the process didn't subscribed to. Can this be connected?

I've done little research in mailing list archives and I found possible cause: table corruption caused by flaky hardware. Does it sound about right? Are there any other possible causes?

What can be corrupted? How can I check it? How can I correct it? What are possible consequences of this corruption? How can I investigate it further?

It's Postgresql 8.0.6 on Linux.

Any help would be greatly appreciated.

Thanks,

Kuba

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to