Thanks Tom. It's all working again now.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, November 14, 2006 6:10 PM
To: Rob Owen
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Out of memory (Failed on request size 24)
"Rob Owen" <Rob.Owen@sas.com> writes:
> Breakpoint 1, 0x00000001000019dc in errfinish () from postmaster
> (gdb) bt
> #0 0x00000001000019dc in errfinish () from postmaster
> #1 0x000000010000a680 in AllocSetAlloc () from postmaster
> #2 0x0000000100002a1c in MemoryContextAlloc () from postmaster
> #3 0x0000000100108c28 in _bt_search () from postmaster
> #4 0x0000000100106484 in _bt_first () from postmaster
> #5 0x00000001001045b4 in btgettuple () from postmaster
> #6 0x0000000100029fb0 in FunctionCall2 () from postmaster
> #7 0x00000001000295f8 in index_getnext () from postmaster
> #8 0x000000010002942c in systable_getnext () from postmaster
> #9 0x000000010000f9a0 in ScanPgRelation () from postmaster #10
> 0x0000000100011088 in RelationBuildDesc () from postmaster
> #11 0x000000010000e6fc in RelationSysNameGetRelation () from
> postmaster
I think you are in luck: this looks like the corrupted data is in one of the indexes on pg_class, so you should be able
torecover by reindexing.
See the man page for REINDEX for the gory details of doing this (you need the "ignore system indexes" option, and maybe
someother pushups depending on your Postgres version).
regards, tom lane