Immediately after switching the page, it will work with CSR.
Please reload your browser to see how it works.
I’m curious: When you say FOR UPDATE SKIP LOCKED does not scale to 25k queries/s, did you observe a threshold at which it became untenable for you?
I’m also curious about the two points of:
- buffered reads and writes
- switching all high-volume tables to use identity columns
What do you mean by these? Were those (part of) the solution to scale FOR UPDATE SKIP LOCKED up to your needs?
Only fix we could find was using unlogged tables and a full vacuum on a schedule. We aren’t big Postgres experts but since you are I was wondering if you have fixed this issue/this framework works well for large payloads.
The open source support and QuickStart are excellent. The engineering work put into the system is very noticeable!
[0] https://github.com/procrastinate-org/procrastinate/
[1] https://github.com/TkTech/chancy