Re: Vacuum error message - Mailing list pgsql-novice

From Kevin Grittner
Subject Re: Vacuum error message
Date
Msg-id 502E4A0D0200002500049887@gw.wicourts.gov
Whole thread Raw
In response to Vacuum error message  (Raymond McKolay <RMcKolay@brittenbanners.com>)
Responses Re: Vacuum error message
List pgsql-novice
Raymond McKolay <RMcKolay@brittenbanners.com> wrote:

> I am new to postgresql and hope this is the correct list to mail
> to.

Sure!  pgsql-general would work, too, but here is fine.

> I have a DB that is out of control huge

Meaning what?  Could you give that in MB, GB, or TB?  What is out
of control about it?

> I tried running a Vacuum on it and received the following error
> Error: could not read block 512591 of relation 1663/16396/16768:
> Result too large

We need more information, especially PostgreSQL version number.
Please post the results of running this query:

http://wiki.postgresql.org/wiki/Server_Configuration

> Any ideas on what this error message means and how I could
> successfully vacuum the DB?

I can't find this error, as you have shown it, in current sources --
so I can't check on what could cause it.  Please double-check that
it matches *exactly* with the message you received, and with a
version number we should be able to track that down.  Oh, and that
last part of the message probably came from the OS, so knowing
exactly what that is might help.

-Kevin


pgsql-novice by date:

Previous
From: Raymond McKolay
Date:
Subject: Vacuum error message
Next
From: Tom Lane
Date:
Subject: Re: Vacuum error message