| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Brooks Lyrette <brooks(dot)lyrette(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Help with postgresql memory issue |
| Date: | 2009-10-28 20:01:14 |
| Message-ID: | 4400.1256760074@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Brooks Lyrette <brooks(dot)lyrette(at)gmail(dot)com> writes:
> I'm new to postgres and it seems my server is unable to fork new
> connections.
> LOG: could not fork new process for connection: Not enough space
For what I suppose is a lightly loaded machine, that is just plain
weird. What's the platform exactly? Is it possible that the postmaster
is being launched under very restrictive ulimit settings?
If it's a Unix-ish machine, it would be useful to look at "top" and
"vmstat" output to see if the machine is under severe memory
pressure for some reason.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brooks Lyrette | 2009-10-28 20:05:44 | Re: Help with postgresql memory issue |
| Previous Message | Richard Huxton | 2009-10-28 20:01:05 | Re: Emal reg expression |