Re: log file? - Mailing list pgsql-general

From
Subject Re: log file?
Date
Msg-id 49174.192.168.1.32.1036520454.squirrel@mainbox.archonet.com
Whole thread Raw
In response to Re: log file?  (Florian Litot <flitot@besancon.sema.slb.com>)
List pgsql-general
> 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




pgsql-general by date:

Previous
From: Florian Litot
Date:
Subject: Re: log file?
Next
From: Bruce Momjian
Date:
Subject: Re: Buffers and MacOS X