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
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 |