Ashish Karalkar <ashish_postgre@xxxxxxxxxxx> writes: > <table cellspacing='0' cellpadding='0' border='0' ><tr><td style="font: inherit;">Hello list members,<br>I hav a table with 140M rows. While I am trying to select the count from the table<br>I am getting following error<br><br>ERROR: shared buffer hash table corrupted<br><br>Can anybody please suggest me wht had gone wrong and how to fix it?<br><br>PostgreSQL 8.2.4<br>OS:Suse 10.3<br><br>With Regards<br>Ashish...<br><br></td></tr></table><br> > <!--3--><hr size=1></hr> Save all your chat conversations. <a href="http://in.rd.yahoo.com/tagline_webmessenger_3/*http://in.messenger.yahoo.com/webmessengerpromo.php">Find them online.</a> Please avoid posting in HTML on these lists ... or at least not HTML-only. As to the problem, can you extract a reproducible test case? It certainly seems like a bug, but it's not one I can recall hearing of before. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/