Speed up starting of Martin

[IncidGeo]

Hi,
Every time i restart Martin it takes quite a long time before the message "Martin has been started" appear (15mn approximately)

• All my source have spatial index
• Some are quite large (87 millions of entries)

Custom configuration file

• Limit to 2 schemas but the database contain nearly 25
• All other settings to default

Should i define the bounding box for each source manually or is there any way to speed up the process ?

[sharkAndshark]

Maybe try set auto_bounds: skip

[IncidGeo]

I've tried
auto_bounds : skip
it's not faster.

Here is my config.yaml file :
postgres:
connection_string: $DATABASE_URL
auto_bounds: skip
auto_publish:
from_schemas:
- webapp
- public

[IncidGeo]

I've activate the debug mode but i don't see anything wrong. This morning it took nearly an half hour to start and i need add much more table in the config file. Any guidance is welcome.

[nyurik]

In the debug mode, can you list all the queries Martin makes? Or send me the log file

[nyurik]

also, after it runs for a few minutes (but before you kill it), open another PG connection in psql or some other tool, and query which queries are running. See https://stackoverflow.com/questions/12641676/how-to-get-a-status-of-a-running-query-in-postgresql-database

[nyurik]

OK, I think the issue was due to using old Martin that did not support bound check skipping properly.

[nyurik]

I added more debug-level logging in #1180 - once released (hopefully soon), it will be easier to trace the source of the bound-calc issues

[IncidGeo]

@nyurik,

I've send you an e-mail with all the logs on the mail you provide in github, let me know if you need more information.

[IncidGeo]

I've just upgrade the docker image to v0.13.0, nearly instant start-up !!!!