We have developed an extension called pg_later for Postgres that allows for asynchronous query execution. This means that you can submit a query and retrieve the results later at your convenience. This feature is particularly useful for long-running maintenance jobs or analytical queries. With pg_later, you can queue up these tasks and continue with other work without blocking your database. The extension is built on top of another extension called PGMQ and seamlessly processes the queries in the background without unnecessary wait times. We are also working on additional features such as status and progress tracking, security and permission models, cursor support, and more. Check out our project on GitHub and give it a try!
https://tembo.io/blog/introducing-pg-later/