From: dev@archonet.com
To: flitot@besancon.sema.slb.com
Cc: dev@archonet.com
Cc: pgsql-general@postgresql.org
Subject: Re: log file?
Date: Tue, 5 Nov 2002 18:20:54 -0000 (GMT)
Message-ID: <49174.192.168.1.32.1036520454.squirrel@mainbox.archonet.com> (raw)
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>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: dev@archonet.com, flitot@besancon.sema.slb.com
Subject: Re: log file?
In-Reply-To: <49174.192.168.1.32.1036520454.squirrel@mainbox.archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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