General discussion

Martin Gainty | 26 Oct 2000 13:53

Re: select count() out of memory

God morgen

Please display these memory settings from your postgresql.conf file
sort_mem
shared_buffers

Takk
Martin--
----- Original Message -----
From: <tfinneid <at> student.matnat.uio.no>
To: "Gregory Stark" <stark <at> enterprisedb.com>
Cc: <tfinneid <at> student.matnat.uio.no>; <pgsql-general <at> postgresql.org>
Sent: Thursday, October 25, 2007 7:07 AM
Subject: Re: [GENERAL] select count() out of memory

> Hi
>
> I have tried to answer to the best of my knowledge but its running on
> Soalris 10, and I am not that familiar with solaris ( Go Linux!!! :)
>
> > any more memory. Either you have a very low memory ulimit (look at
ulimit
> > -a
> > in the same session as Postgres) or your machine is really low on
memory.
> > Perhaps you have shared_buffers set very high or some other program is
> > using
> > all your available memory (and swap)?
> >
>

(Continue reading)

headers

tfinneid | 25 Oct 2007 14:21

Re: select count() out of memory

> God morgen
>
> Please display these memory settings from your postgresql.conf file
> sort_mem
> shared_buffers

I have shown the entire configuration. if its not in the configuration
shown, I have changed its value.

I have used the configuration example provided by Sun regarding running
postgres on solaris.

http://www.sun.com/servers/coolthreads/tnb/applications_postgresql.jsp

regards

thomas

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

headers

tfinneid | 25 Oct 2007 16:16

Re: select count() out of memory

> I have shown the entire configuration. if its not in the configuration
> shown, I have changed its value.

I meant to say "I haven't changed its value"

thomas

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings