Project

General

Profile

Support #14897

Many categories are missing from gisaf

Added by Selvarani C about 1 year ago. Updated about 1 year ago.

Status:
Resolved
Priority:
Urgent
Assignee:
Target version:
-
Start date:
20/03/2023
Due date:
% Done:

0%

Close

Description

Dear Philippe,

After Lunch we had noticed that some of the categories are missing from Gisaf Map.
(EX- Building platform, topo-elevation..., )
Please check it.

History

#1 Updated by Philippe May about 1 year ago

OK. I have upgraded the operating systems of all the servers (including postgres server version from 12 to 15), this might be related. Taking this as high priority, but i'm very busy today.

#2 Updated by Philippe May about 1 year ago

  • Assignee changed from Philippe May to Selvarani C
  • Status changed from New to Resolved

I think it is fixed. Short technical explanation below:

After spending quite a lot of time, i'm quite sure now that the issue comes from the "statistics collector" of new version of Postgres, which was updated from version 12 to 15.

Gisaf uses these statistics data to count the number of features for each layer on the map, and to hide the layers which are empty.

I ran the "ANALYSE" command (https://www.postgresql.org/docs/current/sql-analyze.html). After this the platform and elevation layers appear, but the count is not accurate. This can be done accurately, but it is a slow operation (several seconds - hardly acceptable). Hopefully a future update of postgres will solve the issue with the stats collector for good.

Also available in: Atom PDF