Weird error

From: Philip Molter <philip(at)datafoundry(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Weird error
Date: 2001-06-27 02:43:52
Message-ID: 20010626214352.G12723@datafoundry.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a Postgres application running right now. The thing is
constantly doing 3-5 updates/sec and 1-2 multi-join selects/sec and
performance is actually doing all right. Unfortunately, as the system
runs, performance degrades, which I guess has been documented, although
I still don't understand why.

To work around this, I have a cron job that runs every hour and vacuum
analyzes the three tables that are actually updated significantly. Most of the time, it works fine, but recently, I've been getting this error:

NOTICE: Child itemid in update-chain marked as unused - can't continue
repair_frag

What causes this and how do I make it stop? When this happens,
whatever table is affected doesn't get analyzed and the database
continues its downward resource spiral.

Thanks in advance,
Philip

* Philip Molter
* DataFoundry.net
* http://www.datafoundry.net/
* philip(at)datafoundry(dot)net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Knight 2001-06-27 02:58:55 Re: Weird error
Previous Message Alex Pilosov 2001-06-27 02:22:29 Re: Blobs in PostgreSQL