Re: "Too many open files in system" error

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(dot)Grittner(at)wicourts(dot)gov
> wrote:

> Jonatan Evald Buus <jonatan(dot)buus(at)cellpointmobile(dot)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
>