From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | ashish_postgre(at)yahoo(dot)co(dot)in |
Cc: | pggeneral <pgsql-general(at)postgresql(dot)org>, ashish(dot)karalkar(at)netcore(dot)co(dot)in |
Subject: | Re: ERROR: shared buffer hash table corrupted |
Date: | 2008-01-14 15:39:17 |
Message-ID: | 14178.1200325157@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Ashish Karalkar <ashish_postgre(at)yahoo(dot)co(dot)in> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-14 15:44:12 | Re: tcp_keepalives_idle ignored |
Previous Message | Shelby Cain | 2008-01-14 15:36:50 | Re: ECPG problem with 8.3 |