Vacuum error message

From: Raymond McKolay <RMcKolay(at)brittenbanners(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Vacuum error message
Date: 2012-08-17 17:45:05
Message-ID: 04DF6FA1889A244FAD25273E58CD65AA035436A4A6@email
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
Facebook<http://www.facebook.com/brittenbanners> | Twitter<https://twitter.com/#!/britteninc> | LinkedIn<http://www.linkedin.com/company/222461?trk=tyah> | YouTube<http://www.youtube.com/user/BrittenBannersInc?blend=1&ob=video-mustangbase> | Blog<http://www.brittenbanners.com/blog>

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Grittner 2012-08-17 18:41:33 Re: Vacuum error message
Previous Message Kevin Grittner 2012-08-15 21:08:38 Re: To get a Table or View like a Calendar with dates