pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed(no subject)
2+ messages / 2 participants
[nested] [flat]
* (no subject)
@ 2006-09-12 19:33 jallgood@the-allgoods.net
2006-09-13 06:35 ` Re: Jim C. Nasby <jim@nasby.net>
0 siblings, 1 reply; 2+ messages in thread
From: jallgood@the-allgoods.net @ 2006-09-12 19:33 UTC (permalink / raw)
To: pgsql-performance
Hello All
I am getting this message in my log files for my database.
LOG: out of file descriptors: Too many open files; release and retry.
At some point the memomy didn't get released and the postmaster reset itself terminating all client connections. I am not sure what direction to go. I can increase the file-max in the kernel but it looks reasonably sized already . Or decrease the max_file_per_process. Has anyone on the list encountered this issue. I am running Postgres 7.4.7.
Thanks
John Allgood
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re:
2006-09-12 19:33 (no subject) jallgood@the-allgoods.net
@ 2006-09-13 06:35 ` Jim C. Nasby <jim@nasby.net>
0 siblings, 0 replies; 2+ messages in thread
From: Jim C. Nasby @ 2006-09-13 06:35 UTC (permalink / raw)
To: jallgood@the-allgoods.net; +Cc: pgsql-performance
On Tue, Sep 12, 2006 at 03:33:08PM -0400, jallgood@the-allgoods.net wrote:
> Hello All
>
> I am getting this message in my log files for my database.
>
> LOG: out of file descriptors: Too many open files; release and retry.
>
> At some point the memomy didn't get released and the postmaster reset itself terminating all client connections. I am not sure what direction to go. I can increase the file-max in the kernel but it looks reasonably sized already . Or decrease the max_file_per_process. Has anyone on the list encountered this issue. I am running Postgres 7.4.7.
PostgreSQL could be using somewhere around as much as
max_files_per_process * ( max_connections + 5 ), so make sure that
matches file-max (the + 5 is because there are non-connection processes
such as the bgwriter).
If that looks OK, some file descriptors might have been left around from
the crash... I know this can happen with shared memory segments. It
normally won't happen with file descriptors, but perhaps it is possible.
If that's the case, a reboot would certainly fix it.
BTW, you should upgrade to the latest 7.4 release.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-09-13 06:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-12 19:33 jallgood@the-allgoods.net
2006-09-13 06:35 ` Re: Jim C. Nasby <jim@nasby.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox