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 889F9D1E138 for ; Fri, 20 Feb 2004 13:55:13 +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 74614-04 for ; Fri, 20 Feb 2004 09:55:10 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 408FED1E0DD for ; Fri, 20 Feb 2004 09:55:06 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1KDt9qH027276; Fri, 20 Feb 2004 08:55:09 -0500 (EST) To: Olivier Hubaut Cc: PgSQL Admin Subject: Re: ANALYZE crashes randomly In-reply-to: <4035EC17.10607@scmbb.ulb.ac.be> References: <40349522.8090401@scmbb.ulb.ac.be> <1732.1077201014@sss.pgh.pa.us> <4035EC17.10607@scmbb.ulb.ac.be> Comments: In-reply-to Olivier Hubaut message dated "Fri, 20 Feb 2004 12:14:31 +0100" Date: Fri, 20 Feb 2004 08:55:09 -0500 Message-ID: <27275.1077285309@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/287 X-Sequence-Number: 12461 Olivier Hubaut writes: > 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! But how many open files are needed by the rest of an OS X system? (I have no idea, but you could probably find out using lsof or a similar tool.) regards, tom lane