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@xxxxxxxxxxxx> wrote:
Jonatan Evald Buus <jonatan.buus@xxxxxxxxxxxxxxxxxxx> wrote:
> [too many files open in system]
You didn't start truncating temporary tables inside a loop somewhere,
> Any insight or suggestions as to where to start digging would be
> greatly appreciated
did you?
http://archives.postgresql.org/pgsql-hackers/2009-08/msg00444.php
-Kevin