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
