search

CrunchyData / pg_tileserv

A very thin PostGIS-only tile server in Go. Takes in HTTP tile requests, executes SQL, returns MVT tiles.
Apache License 2.0
846 stars 160 forks source link

pg partionned tables #179

Open Gis-Druide opened 1 year ago

Gis-Druide commented 1 year ago

good morning Paul,

i am running european cadastre data and i need the partionning feature (attach partition syntax). pg15 postgis 3.3 it seems reading the main table does not work (bounds error in docker logs), but reading a view of the main table works.

thank you for your excellent work.

pramsey commented 1 year ago

Would you mind sharing the whole error from the logs?

Gis-Druide commented 1 year ago

INFO[8356] GET /gouv.cad_parcelle.html method=GET url=/gouv.cad_parcelle.html INFO[8356] GET /gouv.cad_parcelle.json method=GET url=/gouv.cad_parcelle.json ERRO[8356] Unable to calculate table bounds ERROR: could not open file "pg_tblspc/0/PG_13_202007201/0/0": No such file or directory (SQLSTATE 58P01) INFO[8461] GET /gouv.cad_parcelle_75.html method=GET url=/gouv.cad_parcelle_75.html INFO[8461] GET /gouv.cad_parcelle_75.json method=GET url=/gouv.cad_parcelle_75.json INFO[8462] GET /gouv.cad_parcelle_75/12/2073/1408.pbf? method=GET url="/gouv.cad_parcelle_75/12/2073/1408.pbf?" INFO[8462] GET /gouv.cad_parcelle_75/12/2074/1408.pbf? method=GET url="/gouv.cad_parcelle_75/12/2074/1408.pbf?" INFO[8863] GET /public.v_cad.html method=GET url=/public.v_cad.html INFO[8864] GET /public.v_cad.json method=GET url=/public.v_cad.json WARN[8864] Estimated extent query failed, run 'ANALYZE public.v_cad' event=request key="Estimated extent query failed, run 'ANALYZE public.v_cad'" topic=detail INFO[8865] GET /public.v_cad/8/129/88.pbf? method=GET url="/public.v_cad/8/129/88.pbf?" INFO[8865] GET /public.v_cad/8/128/88.pbf? method=GET url="/public.v_cad/8/128/88.pbf?" INFO[8865] GET /public.v_cad/8/130/88.pbf? method=GET url="/public.v_cad/8/130/88.pbf?" INFO[8865] GET /public.v_cad/8/128/87.pbf? method=GET url="/public.v_cad/8/128/87.pbf?" INFO[8865] GET /public.v_cad/8/130/87.pbf? method=GET url="/public.v_cad/8/130/87.pbf?" INFO[8865] GET /public.v_cad/8/129/87.pbf? method=GET url="/public.v_cad/8/129/87.pbf?" INFO[8865] GET /public.v_cad/8/131/88.pbf? method=GET url="/public.v_cad/8/131/88.pbf?" INFO[8865] GET /public.v_cad/8/131/87.pbf? method=GET url="/public.v_cad/8/131/87.pbf?"

in this example, the main table (cad), the child table (cad_75), and the view on main table (v_cad) are correctly referenced into the geometry_columns view. i have the same log with pg13 and pg15.

pramsey commented 1 year ago

Could you also give me the SQL defns of the tables of interest?