Thanks Tom for your quick reply. We are using 9.1.3. We got some information on internet regarding this and also found bug IDs:
You have any idea is these bugs are fixed in any release or fixed in latest 9.3.5? We are in blocking stage as many users depend on this. Can you please help us in resolution? BUG #9187: corrupt toast tables http://www.postgresql.org/message-id/30154.1392ds [email protected] http://www.postgresql.org/message-id/cafj8praufpttn5+ohfqpbcd1jzkersck51uakhcwd8nt4os...@mail.gmail.com http://www.postgresql.org/message-id/[email protected] BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328 http://www.postgresql.org/message-id/[email protected] Regards Tarkeshwar -----Original Message----- From: Tom Lane [mailto:[email protected]] Sent: 15 January 2015 20:16 To: M Tarkeshwar Rao Cc: [email protected] Subject: Re: [GENERAL] can you have any idea about toast missing chunk issu resolution M Tarkeshwar Rao <[email protected]> writes: > ERROR: missing chunk number 0 for toast value 54787 in pg_toast_2619 What PG version is that exactly? If you're not running the latest minor release in your branch, updating would be advisable; there have been fixes in the past for bugs with symptoms like this. If you still see the issue after updating, an ANALYZE on the problem table would probably help. regards, tom lane -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
