[Qgis-developer] [Server] performance questions

[Alessandro Pasotti]

2016-02-23 16:29 GMT+01:00 Régis Haubourg <
regis.haubourg at eau-adour-garonne.fr>:

> Alessandro Pasotti-2 wrote
> >
> > Hi,
> >
> > For your point 2, is this bug related to your issue
> > http://hub.qgis.org/issues/13232 ?
> >
> > --
> > Alessandro Pasotti
> > w3:   www.itopen.it
>
> Hi Alessandro,
> probably not, we do not have inherited tables and we have autovacuum
> activated. St_estimated_extent is correctly called when loading postgis
> tables. The matter is that we use very few table, but mainly views and
> materialized views. Postgres does not collect metadatas on views:
>  See https://trac.osgeo.org/postgis/ticket/510
> Having that would be a great improvement. I would be avalaible for funding.
> I already asked to postgres community and had no feedback.. maybe I asked
> the wrong place.
>

The answer from strk  makes sense to me, I might be wrong but calculating
estimated metadata on a query doesn't make much sense to me.



> Any idea concerning multithreading configuration?
>
>
>
Sorry, don't, but I'll have a look.

-- 
Alessandro Pasotti
w3:   www.itopen.it
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20160223/78b34145/attachment-0001.html>