Re: Connection pooling

From: andy <andy(at)squeakycode(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Connection pooling
Date: 2013-10-31 20:09:58
Message-ID: 5272B916.2080503@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/31/2013 11:15 AM, John R Pierce wrote:
> On 10/31/2013 5:34 AM, si24 wrote:
>> It seems for each person that they seem to get about +-20 or more
>> connections each depending on there use of the map if they add the layers
>> that are overlyed over the map like zones etc...
>
> that sounds really broken.
>
>
>

I'm not sure if geoserver is like openLayers/mapserver, but in the later
case (which I use), you can set it up to have the browser (running
openLayers) request multiple layers at the same time... and on top of
that each layer can be requested in tiles. (That way when you drag the
map it only has to load new tiles, and not the entire image, which makes
the animations smooth)

Anyway, one webclient * 5 layers * tiles = lot and lots and lots of web
requests (which, would make lots of db hits).

If geoserver is like openLayers/mapserver, that is.

-Andy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message andy 2013-10-31 20:16:52 Re: Explanantion on pgbouncer please
Previous Message Dann Corbit 2013-10-31 18:53:24 postgresql-9.3.1-1-windows-x64.exe does not install correctly for me