On Mon, Feb 9, 2009 at 8:23 AM, Matt Magoffin <postgresql.org@xxxxxxx> wrote: > I just noticed something: the "open files" limit lists 1024, which is the > default for this system. A quick count of open data files currently in use > by Postgres returns almost 7000, though. > > [root@170226-db7 ~]# lsof -u postgres |egrep > '(/pg_data|/pg_index|/pg_log)' |wc -l > 6749 > > We have 100+ postgres processes running, so for an individual process, > could the 1024 file limit be doing anything to this query? Or would I see > an explicit error message regarding this condition? you would get one of "Open files rlimit 1024 reached for uid xxxx" in syslog (which you should checkout anyhow). I wonder if it isn't just another one of those 'this only happends on 64bit machine' problems :) -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
