I don't understand the latency graph. It says it has 0.25ms consumer latency.

Then in the latency tradeof section it says end to end latency is between 1-2 seconds.

Is this under heavy load or always? How does this compare to pgmq end to end latency?

(PgQue author here)

I didn't understand nuances in the beginning myself

We have 3 kinds of latencies when dealing with event messages:

1. producer latency – how long does it take to insert an event message?

2. subscriber latency – how long does it take to get a message? (or a batch of all new messages, like in this case)

3. end-to-end event delivery time – how long does it take for a message to go from producer to consumer?

In case of PgQ/PgQue, the 3rd one is limited by "tick" frequency – by default, it's once per second (I'm thinking how to simplify more frequent configs, pg_cron is limited by 1/s).

While 1 and 2 are both sub-ms for PgQue. Consumers just don't see fresh messages until tick happens. Meanwhile, consuming queries is fast.

Hope this helps. Thanks for the question. Will this to README.

Not the original commenter but this is an excellent answer, thanks for the clear explanation — this is what people continue to come to HN for IMO.

Also thanks for all the podcasts and content, always a joy to watch.

thank you!

yeah I also really liked the font and graphs. maybe its https://plus.excalidraw.com/virgil?

We use pgmq with the pgmq-go client, and it has clients in many different languages, it's amazing. The queues persist on disk and visualizations of queues can easily be made with grafana or just pure sql requests. The fact that the queues lives in the same database as all the other data is also a huge benefit if the 5-15ms time penalty is not an issue.

Nuclear Negligence examines safety weaknesses at U.S. nuclear weapon sites operated by corporate contractors.

At last they didn't call it freeai

Are outgoing ports blocked by the university? Wireguard servers usually use port 5000. http://portquiz.net:5000/

I run wireguard servers on many ports, including 53, 443 and 5-figure numbers. I don't think I've got 5000 anywhere though.

Same. Not that it means much, but I've been seeing 51820 being used in all documentation, blog posts, etc. Probably just copypasting the original examples, e.g.

https://www.wireguard.com/quickstart/

https://www.wireguard.com/xplatform/

A month ago I dug through the history, the only trace to origin of using 51820/UDP I've found is that the number is hardcoded in one of the tests.

Wow this Portquiz thing is great!

The video brings up that the same auction house was involved in the coin collection bubble in the 80s and had to settle with the FTC then.

So free as in open source, why is this called free and not open then?

Free is a term used by the community for decades, literally in the name of the Free Software Foundation. I guess you could argue that their need to explain what free means indicates it was a bad choice to use, but it is pretty standard now.

https://www.fsf.org/about/what-is-free-software