X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C46BAD1E0BB for ; Fri, 20 Feb 2004 11:14:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24674-08 for ; Fri, 20 Feb 2004 07:14:24 -0400 (AST) Received: from guppy.vub.ac.be (guppy.vub.ac.be [134.184.129.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5CECFD1DFFE for ; Fri, 20 Feb 2004 07:14:17 -0400 (AST) Received: from mach.vub.ac.be (mach.vub.ac.be [134.184.129.3]) by guppy.vub.ac.be (8.9.1b+Sun/3.17.1.ap (guppy)) id MAA01989; Fri, 20 Feb 2004 12:14:18 +0100 (MET) for Received: from scmbb.ulb.ac.be (ucmbsgi10.ulb.ac.be [164.15.109.34]) by mach.vub.ac.be (8.9.3/3.13.5.aejp (mach)) id MAA24745; Fri, 20 Feb 2004 12:14:17 +0100 (MET) for Message-ID: <4035EC17.10607@scmbb.ulb.ac.be> Date: Fri, 20 Feb 2004 12:14:31 +0100 From: Olivier Hubaut User-Agent: Mozilla Thunderbird 0.5 (Macintosh/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: PgSQL Admin Subject: Re: ANALYZE crashes randomly References: <40349522.8090401@scmbb.ulb.ac.be> <1732.1077201014@sss.pgh.pa.us> In-Reply-To: <1732.1077201014@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/285 X-Sequence-Number: 12459 Tom Lane wrote: > Olivier Hubaut writes: > >>PANIC: could not open transaction-commit log directory >>(/usr/local/pgsql/annot/pg_clog): Too many open files > > > Try reducing max_files_per_process (in postgresql.conf) and/or > increasing the kernel's limit on number of open files (I think > you set this via sysctl in /etc/rc, but it may vary depending on > OS X version). > > regards, tom lane > Thank you, it works fine by reducing the max_files_per_process to 200 (instead of the default '1000' value). But it's amazing to me that i had to reduce it so much as the postmaster is almost the only application running on this server. There only 3 or 4 simultaneous connections and the kernel max files is set to 12500! Is that comportement normal or not? -- Signature en cours de maintenance, Veuillez patienter...