Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

startup take too long time with many postgis tables #284

Closed
tarikcarli opened this issue Mar 10, 2022 · 1 comment
Closed

startup take too long time with many postgis tables #284

tarikcarli opened this issue Mar 10, 2022 · 1 comment
Labels

Comments

@tarikcarli
Copy link

Hi all, I have a postgresql that contains lots of spatial tables and tables will continue to take place in my database. I have to dynamically add tables that added later to trex configuration and serve those tables. If I change trex configuration and restart tileserver, It took at least 3 minutes to be serve tiles. Is there a way to dynamically add table layer to trex without restart or any suggestion to overcome this issue.

@pka pka added the question label Mar 13, 2022
@pka
Copy link
Member

pka commented Mar 13, 2022

Automatic geometry detection can take a lot of time, when there are many tables. You can disable it with

t_rex serve --detect-geometry-types false ....

A long time enhancement wish is a schema/table filter for limiting geometry detection.

@pka pka changed the title startup take too long time with postgis startup take too long time with many postgis tables Mar 13, 2022
@pka pka closed this as completed Apr 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants