Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 87D49475ADD for ; Tue, 5 Nov 2002 13:30:07 -0500 (EST) Received: from anchor-post-39.mail.demon.net (anchor-post-39.mail.demon.net [194.217.242.80]) by postgresql.org (Postfix) with ESMTP id DDBC7475A1E for ; Tue, 5 Nov 2002 13:30:06 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-39.mail.demon.net with esmtp (Exim 3.36 #2) id 1898Sk-0006EO-0U; Tue, 05 Nov 2002 18:30:06 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id CECAF17921; Tue, 5 Nov 2002 18:20:54 +0000 (GMT) Received: from archonet.com (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with SMTP id 3207E1791E; Tue, 5 Nov 2002 18:20:54 +0000 (GMT) Received: from 192.168.1.32 (SquirrelMail authenticated user dev) by mainbox.archonet.com with HTTP; Tue, 5 Nov 2002 18:20:54 -0000 (GMT) Message-ID: <49174.192.168.1.32.1036520454.squirrel@mainbox.archonet.com> Date: Tue, 5 Nov 2002 18:20:54 -0000 (GMT) Subject: Re: log file? From: To: In-Reply-To: <4.3.2.7.2.20021105182318.00c291e0@pop.besancon.tt.slb.com> References: <4.3.2.7.2.20021105171100.00d89ea0@pop.besancon.tt.slb.com> <4.3.2.7.2.20021105121304.022c5100@pop.besancon.tt.slb.com> <4.3.2.7.2.20021105171100.00d89ea0@pop.besancon.tt.slb.com> <4.3.2.7.2.20021105182318.00c291e0@pop.besancon.tt.slb.com> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: , X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/171 X-Sequence-Number: 32592 > the number of files increase > my database is always connected > i use a jdbc driver and a program is always connected to the database > and send sometimes insertion > hav you got an idea? The only thing I know of that can cause this is an old transaction still being required because a connected client might need it. Could this be the case? I don't know what version of PG you are using, but recent ones let you see what queries are in progress via the statistics views. See pg_stat... in the manual and the mailing list archives. It's evening here, so I'll post again tomorrow. -- Richard Huxton