Memory exhausted in AllocSetAlloc()

Folks,

During the last database load, our database under 6.5.1
grew from about 40Gb to 62Gb. This database consists
of one table, "psc". The simple query

select count(*) from psc;

gives me the following in the log:

------------------------------------------------------------
FATAL 1: Memory exhausted in AllocSetAlloc()
proc_exit(0) [#0]
shmem_exit(0) [#0]
exit(0)
------------------------------------------------------------

An earlier attempt to create an index also failed:

------------------------------------------------------------
query: create index gcoord on psc using btree (glon, glat);
ProcessUtility: create index gcoord on psc using btree (glon, glat);
/usr/lib/postgresql/bin/postmaster: reaping dead processes...
/usr/lib/postgresql/bin/postmaster: CleanupProc: pid 15979 exited with status 11
/usr/lib/postgresql/bin/postmaster: CleanupProc: reinitializing shared memory and semaphores
shmem_exit(0) [#0]
binding ShmemCreate(key=52e325, size=29679616)
------------------------------------------------------------

Any suggestions? Have I reached limits database size limits in pgsql?

Thanks!!

--Martin

===========================================================================

Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower weinberg(at)astro(dot)umass(dot)edu
University of Massachusetts http://www.astro.umass.edu/~weinberg/
Amherst, MA 01003-4525