Re:pg_durable: Microsoft open sources in-database durable ex...
by otterley on Saturday June 06, 2026 @12:48AM
(#48421482)
Why would using a stored procedure reduce I/O? I can see it reducing network round trips, but not storage reads and writes.
[ Parent
| on HN ]
Re:pg_durable: Microsoft open sources in-database durable ex...
by dpark on Saturday June 06, 2026 @02:39AM
(#48422057)
I was referring to network I/O. But disk I/O should be at least as good for a stored procedure and often better. It’s classic “bring the computation to the data”. Putting the computation into the DB means that use of disk caching (up to and including CPU caching) is maximized.
Pulling the data out of the DB to do computation in a higher layer cannot be more efficient in terms of any I/O unless your stored procedure is just poorly written. It might be a win if your DB is compute bound, though.