Skip site navigation (1) Skip section navigation (2)

Re: "Too many open files in system" error

From: Jonatan Evald Buus <jonatan(dot)buus(at)cellpointmobile(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: "Too many open files in system" error
Date: 2009-08-12 19:17:41
Message-ID: 113ce31b0908121217k4585b1bbqca9b6f5b3b4ce72d@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(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
>

In response to

pgsql-admin by date

Next:From: Adam RuthDate: 2009-08-12 22:06:33
Subject: Windows 7 and SSPI
Previous:From: Kevin GrittnerDate: 2009-08-12 19:02:00
Subject: Re: "Too many open files in system" error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group