Hi all, Currently, bgworkers offer the possibility to connect to a given database using BackgroundWorkerInitializeConnection in bgworker.h, but there is actually no way to disconnect from a given database inside the same bgworker process.
One of the use cases for that would be the possibility to have the same bgworker performing for example some analysis on a database A, like some analysis of statistics using a common database like postgres, and then perform some actions on another database like, let's imagine an ANALYSE on a given relation only on database B. Using the infrastructure of 9.4 as of now, it would be possible of course to have a bgworker process launching some other child processes dynamically on different databases, but users (including me) might not want to do that all the time. Database disconnection would be also pretty cool for things like parallel query processing using a pool of bgworker processes that all the backends could use in parallel as a single ressource. Note that I didn't have a look at the code yet to see how it would be possible to do that (looks tricky though), if any infrastructure is needed or if it could be possible to do that without modifying the core code of Postgres. So, opinions about that as well as additional thoughts are welcome! Regards, -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
