jtregunna

Just an investigation and deep dive from first principles.

In what sense? The phrasing is just a generalization, production-grade anything needs consideration of the needs and goals of the project.

Right, you do need to fsync when creating new files to ensure the directory entry is durable. However, WAL files are typically created once and then appended to for their lifetime, so the directory fsync is only needed at file creation time, not during normal operations.

Update:

I updated the post based on the conversation below, I wholly missed an important callout about performance, and wasn't super clear that you do need to wait for the completion record to be written before responding to the client. That was implicitly mentioned by writing the completion record coming before responding, but I made it clearer to avoid confusion.

Also the dual WAL approach is worse for latency, unless you can amortize the double write over multiple async writes, so the cost paid amortizes across the batch, but when batch size is closer to 1, the cost is higher.

Post talks about how to use io_uring, in the context of building a "database" (a demonstration key-value cache with a write-ahead log), to maintain durability.

Actually, this is exactly why Canada should be looking for other markets. The US has clearly indicated to us that we can no longer rely on them for trade. It's long overdue, but now is the time we need to act in reducing our dependence on the US, since clearly one dumbass can impact our economy in ways that one dumbass shouldn't be able to.

> Secret courts are a shame. Secret directives, on the other hand, can be compatible with the rule of law and an independent judiciary, provided they're lawfully authorized and can be challenged in a court.

I presume you also forgot to add this before challenged in a court...

> ..., whistleblowers are protected, and can be ...

You see, because that's the thing with secret directives, they're redacted from the public eye. The only way we get visibility into them isn't with FOIA requests, it's with whistleblowers who feel the government is doing things wrong, and if they're not protected, they rarely come forward.

Textbook nonsequiter, well done.

Uh, not my intent. I'm trying to illustrate that Canada has command and control regulations regarding telecommunication providers that operate in the country, and there are requirements for Canadian control. If equipment were factored into such decisions, that could go a way into resolving this problem. Though it'd probably create others. And for completeness, it's still Canada's decision to make, the rhetoric the US has been sending our way has left many of us feeling like the once good friend and neighbour, has decided that we're a threat to their national security.

EDIT: Clicked too soon.

Sure, doesn't hurt to listen, but at the end of the day, that's just being polite. A courtesy. The decision is still entirely Canada's, and shouldn't be influenced by US congress critters.

Sure, just saying, Canada should review any orders it makes towards telecom companies (full disclosure, I started and ran a telecom company from 2001 until 2010) from entirely a Canadian perspective and not account for any input from the US; doubly so given how the US government (like it or not, Trump is their president and reflects their government internationally) has treated Canada over the last year and a half.