| 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: | Whole Thread | Raw Message | 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 |