Re: Cannot start Postgres- FATAL: invalid cache id: 19

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Cannot start Postgres- FATAL: invalid cache id: 19
Date: 2010-12-01 18:27:00
Message-ID: AANLkTimCF=1wDCeJY4WBTb4T_5=z-54wZJdMjnZivOoi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 1, 2010 at 11:23 AM, Jolles, Peter M (GE Energy)
<peter(dot)jolles(at)ge(dot)com> wrote:
> EST WARNING:  database "fps_data" must be vacuumed within 11000000 transactions
>
> I know now that I'm going to have to slow down the transaction rate in order to let the autovacuum keep up, but at this point I am just trying to salvage the data present in the database.
>

Just how big is the table and how many transactions per second do you
push through it? Perhaps your I/O bandwidth is just insufficient for
your load level.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2010-12-01 18:49:55 Re: How to find correct locale name for CREATE DATABASE
Previous Message Anibal David Acosta 2010-12-01 17:11:22 How to recover a postgres installation from files