Re: Connections sitting idle... - Mailing list pgsql-odbc

From Raymond O'Donnell
Subject Re: Connections sitting idle...
Date
Msg-id 3DF5F6B7.6203.5DB4E52@localhost
Whole thread Raw
In response to Re: Connections sitting idle...  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-odbc
On 10 Dec 2002 at 13:53, Dave Page wrote:

> I think its 40K (iirc). Can you zip/gzip the files?

Ah! - that would do it. Zipped files are attached, and the original
covering email follows.

--Ray.

--------------------
I've attached two logs: the "single instance" one was generated by
clicking my way through the web app in a single browser window, while
the
other was generated from three different browser windows at the same
time.

With three copies of the app running, I had at times nine idle
backends on the database machine, which as far as I could tell hung
around for about 80s each - I times two or three at random, and the
rest seems subjectively to last about the same amount of time. This
was with connection pooling turned *on* - no obvious reuse of
connections - each page opened a new connection, even though the
connection parameters are the same every time.

This machine was running Windows Me and Personal Web Server. I'll be
trying it out on a Win2K machine in the morning.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any another MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  logs.zip
     Date:  10 Dec 2002, 14:11
     Size:  5980 bytes.
     Type:  ZIP-archive

Attachment

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Connections sitting idle...
Next
From: Mauro Goncalves de Oliveria
Date:
Subject: ...