table overflow question - Mailing list pgsql-general

From Williams, Travis L, NPONS
Subject table overflow question
Date
Msg-id AB815D267EC31A4693CC24D234F8291602AD5A90@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: table overflow question  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
All,
    I have a script that will fork off x number of process ... each one of these opens a connection to the db polls a
differentserver and polls 200+ mibs.  I am doing a update after every poll (so 1 poll (out of 200) then a update.. then
anotherpoll and update and so on till 200).  So I have 5 db connections each doing a update to the same table but to
differentrows.  Now this works ok.  and it work ok if I go up to 10 connections at once.. but any more than that and I
getthe error "Can't Connect to DB: FATAL 1:  cannot open pg_class: File table overflow" now is this to be expected.. or
isthere some performace tweak I can add.. btw I am running on a hpux 11.11 dual 550 512M. 

Thanks,

Travis


pgsql-general by date:

Previous
From: "Gyorgy Molnar"
Date:
Subject: Re: creating a new type in C
Next
From: Martijn van Oosterhout
Date:
Subject: Re: table overflow question