Skip to content
This repository has been archived by the owner on Oct 13, 2018. It is now read-only.

postgres bottleneck? #2

Open
balazsdukai opened this issue Aug 10, 2017 · 0 comments
Open

postgres bottleneck? #2

balazsdukai opened this issue Aug 10, 2017 · 0 comments

Comments

@balazsdukai
Copy link
Owner

batch3dfier reads the footprints from postgres views and opens a single connection for all the operations. Apparently prior version 9.6, postgres can only use one CPU thread/core at a time. I'm not sure about it, but this might mean that regardless of how concurrency is implemented, the bottleneck might become the I/O from postgres as it can only run on a single thread (because there is a single open connection). It seems like that this problem could be side-stepped by opening a separate postgres connection for each thread.

@balazsdukai balazsdukai added this to the 1.0.0 milestone Aug 10, 2017
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

1 participant