Re: "Too many open files in system" error

Поиск
Список
Период
Сортировка
От Jonatan Evald Buus
Тема Re: "Too many open files in system" error
Дата
Msg-id 113ce31b0908121217k4585b1bbqca9b6f5b3b4ce72d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: "Too many open files in system" error  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin
Дерево обсуждения
Nope, though that sounds fun!! ;-)

The application hasn't really changed much over the past 6 months either (and definitively not its use of the database which is mainly INSERT queries used for logging a few SELECTS for sharing data between the clustered application nodes, all in all pretty simply and straight forward)

/Jona

On Wed, Aug 12, 2009 at 9:02 PM, Kevin Grittner <Kevin.Grittner@wicourts.gov> wrote:
Jonatan Evald Buus <jonatan.buus@cellpointmobile.com> wrote:

> [too many files open in system]

> Any insight or suggestions as to where to start digging would be
> greatly appreciated

You didn't start truncating temporary tables inside a loop somewhere,
did you?

http://archives.postgresql.org/pgsql-hackers/2009-08/msg00444.php

-Kevin

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: "Too many open files in system" error
Следующее
От: Adam Ruth
Дата:
Сообщение: Windows 7 and SSPI