From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Gabriel Dovalo Carril <dovalo(at)teleline(dot)es> |
Cc: | PostgreSQL jdbc list <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: libpq++ and Postgres |
Date: | 2002-03-04 19:21:18 |
Message-ID: | 200203041921.g24JLJA24515@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
No idea. Let me CC this to the jdbc list.
Gabriel Dovalo Carril wrote:
>
> Hi,
>
> I've found a message, searching in google, you have sent last year,
> and I'n having the same problem you got.
> I would like to know if you have found a solution to it
>
> I'm using postgresql-7.0.3-6 and even having 36000 file descriptors
> available in the server, Postgres fails.
>
> What can be done?
>
> Thanks in advance.
>
> --
> Gabriel Dovalo.
>
> > [ Charset ISO-8859-1 unsupported, converting... ]
> > > I have a problem with postgres freeing resouces.
> > >
> > > Consider the following routine.
> > >
> > > int foo()
> > > {
> > > PgDatabase *pDatabase = new PgDatabase(cpDBName);
> > >
> > >
> > > // Use the connection, insert a record etc.
> > >
> > > delete pDatabase;
> > > }
> > >
> > > The delete call does not cause system resources to be freed, such
> > > as the socket connection. If you call this function about 1010 times,
> > > postgres will fail, stating that there are no system resources, too
> > > many open files.
> > >
> > > I am using postgrex 6.x
> > >
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Eric Scroger | 2002-03-04 20:28:57 | JDBC: java.sql.SQLException: results returned |
Previous Message | Bruce Momjian | 2002-03-04 19:03:40 | Open patches |