pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: borajetta <borajetta@hotmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: REINDEX needed because of index corruption need help ASAP
Date: Fri, 13 Aug 2004 15:18:41 -0700
Message-ID: <200408131518.41992.josh@agliodbs.com> (raw)
In-Reply-To: <BAY17-DAV19wtcLQVSd00012b07@hotmail.com>
References: <BAY17-DAV19wtcLQVSd00012b07@hotmail.com>

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




view thread (3+ messages)  latest in thread

Message-ID: <200408131518.41992.josh@agliodbs.com>
Permalink:  ../200408131518.41992.josh@agliodbs.com/
Also on:    postgresql.org/message-id/200408131518.41992.josh@agliodbs.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com, borajetta@hotmail.com
  Subject: Re: REINDEX needed because of index corruption need help ASAP
  In-Reply-To: <200408131518.41992.josh@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox