Thread: Memory exhausted in AllocSetAlloc()

Memory exhausted in AllocSetAlloc()

From
Martin Weinberg
Date:
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@astro.umass.edu
University of Massachusetts         http://www.astro.umass.edu/~weinberg/
Amherst, MA  01003-4525