Help with: Memory exhausted in AllocSetAlloc()

From: Martin Weinberg <weinberg(at)osprey(dot)astro(dot)umass(dot)edu>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Help with: Memory exhausted in AllocSetAlloc()
Date: 1999-09-19 14:08:39
Message-ID: 199909191408.KAA04418@osprey.astro.umass.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Any suggestions on fixing this?

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

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 1999-09-19 14:57:40 Re: [INTERFACES] PERL
Previous Message Palle Girgensohn 1999-09-19 11:42:59 Re: [GENERAL] pgaccess removed from 6.5.2?