[GENERAL] close connection more expensive that open connection?

2011-03-02 Thread Rob Sargent
A developer here accidentally flooded a server with connection opens and closes, essentially one per transaction during a multi-threaded data migration process. We were curious if this suggests that connection clean up is more expensive than creation thereby exhausting resources, or if perhaps the

Re: [GENERAL] close connection

2008-01-28 Thread Douglas McNaught
On 1/28/08, Dominique Bessette - Halsema <[EMAIL PROTECTED]> wrote: > > > > I dont really understand the question but here's an xml example of what is > getting posted to postgres, and i'm trying to figure out how to do a > connection.close() type of thing in it. > > Postgres doesn't have a built-

Re: [GENERAL] close connection

2008-01-28 Thread Dominique Bessette - Halsema
i forgot to add on the xml code http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd http://www.opengeospatial.net/cite http://:/geoserver/wfs/DescribeFeatureType?typename=cite:tracks,cite:alias " xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:cite="

[GENERAL] close connection

2008-01-28 Thread Dominique Bessette - Halsema
I dont really understand the question but here's an xml example of what is getting posted to postgres, and i'm trying to figure out how to do a connection.close() type of thing in it. http://www.opengis.net/wfs http://schemas.opengis.net/wfs/1.0.0/WFS-transaction.xsd http://www.opengeospatial.n

Re: [GENERAL] close connection

2008-01-24 Thread Erik Jones
On Jan 24, 2008, at 3:47 PM, Dominique Bessette - Halsema wrote: is there a way to close the connection in postgres after i insert something? Of course. Exactly how will be dependent on what you're using to access the db (language/framework-wise). Erik Jones DBA | Emma® [EMAIL PROTECT

Re: [GENERAL] close connection

2008-01-24 Thread Dominique Bessette - Halsema
I'm http posting postgres from my wfs. in otherwords i'm postgres is my datastore and i'm posting xml to it. so do you know how to close it in xml? On 1/24/08, Bill Moran <[EMAIL PROTECTED]> wrote: > > "Dominique Bessette - Halsema" <[EMAIL PROTECTED]> wrote: > > > > is there a way to close the

Re: [GENERAL] close connection

2008-01-24 Thread Bill Moran
"Dominique Bessette - Halsema" <[EMAIL PROTECTED]> wrote: > > is there a way to close the connection in postgres after i insert something? > The short answer is "yes". In order to provide a more detailed answer, I suspect you're going to have to provide a little more context ... are you writing

[GENERAL] close connection

2008-01-24 Thread Dominique Bessette - Halsema
is there a way to close the connection in postgres after i insert something?