Re: log file?

Поиск
Список
Период
Сортировка
От
Тема Re: log file?
Дата
Msg-id 49174.192.168.1.32.1036520454.squirrel@mainbox.archonet.com
обсуждение исходный текст
Ответ на Re: log file?  (Florian Litot <flitot@besancon.sema.slb.com>)
Список 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 по дате отправления:

Предыдущее
От: Florian Litot
Дата:
Сообщение: Re: log file?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Buffers and MacOS X