Aaron, > We are getting this error for other index's including primary key indexs where we get OID page not found errors and the index corruption as posted above. > Sometimes when the index is broken it will cause run away searches which eat up all the memory and the server needs to be restarted.
What version of PostgreSQL are you using? Do you have frequent power-outs on the machine? Have you tested for bad hard drive, controller, or memory? Corruption of any kind on PostgreSQL is not normal. It's usually indicative of a hardware problem. -- -Josh Berkus "A developer of Very Little Brain" Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly