Home > mailing lists

Vacuum error message - Mailing list pgsql-novice

From	Raymond McKolay
Subject	Vacuum error message
Date	August 17, 2012 20:45:13
Msg-id	04DF6FA1889A244FAD25273E58CD65AA035436A4A6@email Whole thread Raw
Responses	Re: Vacuum error message ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) Re: Vacuum error message (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-novice

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

I have a DB that is out of control huge and 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

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

Ray

Ray McKolay

IT | Britten, Inc.

Office 231.995.8530 Toll Free 800.426.9496

From: "Kevin Grittner"
Date: 16 August 2012, 00:08:47
Subject: Re: To get a Table or View like a Calendar with dates

From: "Kevin Grittner"
Date: 17 August 2012, 21:41:45
Subject: Re: Vacuum error message