Re: [postgis-users] Qgis + PostGis. Low operating speed.

2022-12-15 Thread Alex German
; when postgis raster access from QGIS was more or less a straight connection > to GDAL. I think that changed in the past 2-3 years or so. > > > > *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On > Behalf Of *Alex German > *Sent:* Wednesday, December 14, 2

Re: [postgis-users] Qgis + PostGis. Low operating speed.

2022-12-13 Thread Alex German
caused an issue with its reading of overviews. > > > > I’ll try to test this out with latest QGIS in sometime this or next week > to verify what the issue is here. > > > > Thanks, > > Regina > > > > > > > > *From:* postgis-users [mailto:postgis-

Re: [postgis-users] Qgis + PostGis. Low operating speed.

2022-12-13 Thread Alex German
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 postgi

Re: [postgis-users] Qgis + PostGis. Low operating speed.

2022-12-12 Thread Alex German
[image: image.png] SRID in postgis 4326 [image: image.png] SRID in QGis 4326 вт, 13 дек. 2022 г. в 12:05, Bo Victor Thomsen : > Is the rasters in same projection (CRS) as the QGIS project ? > > Med venlig hilsen / Best regards > > Bo Victor Thomsen > > Den 13-12-2022 kl. 07

Re: [postgis-users] Qgis + PostGis. Low operating speed.

2022-12-12 Thread Alex German
n QGIS > > > > raster2pgsql -s 4326 -t 256x256 -C -I -F "d:\Temp\060 tiff\res\OCG_t1.tif" > OCG_t1 -R| psql. > > > > > > *From:* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *On > Behalf Of *Alex German > *Sent:* Monday, Dec

[postgis-users] Qgis + PostGis. Low operating speed.

2022-12-12 Thread Alex German
sql. The number of files is more than 1000. When trying to load tables in QGis, the loading is very slow. At the same time, downloading to QGis from files is fast. Question. What is not configured correctly and how to speed up the download to Qgis from PostGIS?

Re: [postgis-users] Problem with raster2psql out-db

2022-11-09 Thread Alex German
be the problem? Alex German чт, 10 нояб. 2022 г. в 08:30, Regina Obe : > The out_db constraint is not filled in unless you include the –C option > to include constraints. > > So I suspect your raster loaded is really out of database. > > > > An easy way to check is run a q

[postgis-users] Problem with raster2psql out-db

2022-11-08 Thread Alex German
Hi, everybody. I need help. I have a problem when using the raster2psql utility. I use the -R key, but the raster is loaded into the raster table, and not as an external file. raster_columns in the out_db field is null raster2pgsql -R //geoserver/t1.tif | psql What am I doing wrong? -- Alex