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 153590@xxxxxxxxxxxxx http://www.postgresql.org/message-id/CAFj8pRAufPtTn5+ohFqPbcd1JzkErsCK51UAkHCWd8nt4osXjA@xxxxxxxxxxxxxx http://www.postgresql.org/message-id/20140211162408.2713.81446@xxxxxxxxxxxxxxxxxxxxxxx BUG #7819: missing chunk number 0 for toast value 1235919 in pg_toast_35328 http://www.postgresql.org/message-id/C62EC84B2D3CF847899CCF4B589CCF70B20AA08F@BBMBX.backbone.local Regards Tarkeshwar -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: 15 January 2015 20:16 To: M Tarkeshwar Rao Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: can you have any idea about toast missing chunk issu resolution M Tarkeshwar Rao <m.tarkeshwar.rao@xxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
