Opened 10 years ago
Last modified 9 years ago
#2724 closed enhancement
PostGIS specific background workers — at Version 1
| Reported by: | robe | Owned by: | pramsey |
|---|---|---|---|
| Priority: | medium | Milestone: | PostGIS 2.2.0 |
| Component: | postgis | Version: | master |
| Keywords: | postgresql 9.4 | Cc: |
Description (last modified by )
Snooping on pgadvocacy http://www.postgresql.org/message-id/CAFj8pRA8+J17PxmmL1B8b-4bfbHvpQPcp7g7rG7Skune=BuY8Q@mail.gmail.com got me thinking.
I admit to not having looked at the background API in PostgreSQL 9.3+. So this is more of a placeholder to investigate, see how useful it is, and if useful add to PostGIS 2.2 additional extensions only installed for those folks running PostgreSQL 9.3+.
Areas I see where background workers might be useful are in obviously long running processes where running in a single transaction is bloody slow and the work needs to be broken up into separate runs.
1) raster processing 2) topology processing 3) tiger geocoder processing
I suspect we'd probably need separate background workers for each tailored to the unique needs of each, but perhaps not.
Thoughts?
