News for hackers. Stuff that matters.
Re:Pg_later: Asynchronous Queries for Postgres by MuffinFlavored on Friday August 18, 2023 @04:36PM (#37181752)
I'm having a hard time understanding. I see that it's basically a queue. Request your query to be inserted, get a job_id back, poll that job_id until it is done.

Under the hood, is the query ran like a normal query?

I guess I don't understand the distinction between "run queries async" or "put query in a queue, run them sync one a time, poll until the one you want is done"

I get how the latter is "async".

Re:Pg_later: Asynchronous Queries for Postgres by chuckhend on Friday August 18, 2023 @05:09PM (#37182131)
It is similar functionality to https://docs.snowflake.com/en/developer-guide/sql-api/refere..., the `async` flag more specifically. You submit the query and are given the job id. A background worker runs it like a normal query, but the caller can go about their business while Postgres handles it for them.