Thanks, Regina! On the Qgis forum, I was told that overviews from PostGIS
to Qgis do not work.
ср, 14 дек. 2022 г. в 09:02, Regina Obe :
> That comes as a big surprise to me. It’s been a while since I’ve used QGIS
> on raster, but last time I tried it was able to read the overview tables.
>
>
>
That comes as a big surprise to me. It’s been a while since I’ve used QGIS on
raster, but last time I tried it was able to read the overview tables.
I know there was a time not too long ago when QGIS was revising how it queries
PostGIS raster. I forget what that revision was about, if it was
Just to put a nail in this one: the last time our selectivity estimates for
Contains/Within were good was version 2.1, which used the && operator instead
of hte ~/@ operators in the SQL wrapper functions.
> On Dec 13, 2022, at 9:04 AM, Paul Ramsey wrote:
>
> On Mon, Dec 12, 2022 at 7:17 PM
On Mon, Dec 12, 2022 at 7:17 PM Regina Obe wrote:
>
> Paul,
>
> Is it the same story with ST_CoveredBy and ST_Covers. I care more about
> those than ST_Contains and ST_Within.
Yes, it's the same story. The only place we use a real selectivity
calculation is in the && operator.
> Maybe part of
Also note there are issues and memory leaks with the PG raster reader in QGIS.
See https://github.com/qgis/QGIS/issues/47815
Jakob
From: postgis-users On Behalf Of Alex
German
Sent: Tuesday, December 13, 2022 10:12 QGIS
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Qgis +
QGis does not pick up overviews.
Separately, overviews are loaded very quickly.
I.e. if I load o_16_t6 in qgis, then the download speed is excellent.
In the properties of the table, there are overviews.
вт, 13 дек. 2022 г. в 12:29, Alex German :
> [image: image.png]
> SRID in postgis 4326
>
loading to QGis from files is fast. Question. What is
not configured correctly and how to speed up the download to Qgis from
PostGIS?
--
Alex German
-- next part --
An HTML attachment was scrubbed...
URL:
<http://lists.osgeo.org/pipermail/postgis-users/attachments