Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Pg_later: Asynchronous Queries for Postgres. Parent comment
The way I've done it is, as you allude to, by managing locks. You set the transaction isolation level as appropriate.
You can also batch statements by using a cursor, rather than having a single large blocking transaction.
There are no comments on this comment yet.
The way I've done it is, as you allude to, by managing locks. You set the transaction isolation level as appropriate.
You can also batch statements by using a cursor, rather than having a single large blocking transaction.