In an effort to understand Postgres better I’ve worked my way through how a Postgres database is structured and executes queries.
Process Model
Postgres uses a process-per-worker model. That means every connection is handled by a separate operating system process forked off the initial process.
Subsystem Overview
Postgres consists of several components that all work together to process data and ensure it’s reliably written and can be looked up efficiently. The following are the most important components, but there more, other components that are beyond the scope of this post.
I've been teaching Claude why we favor Markdown. "We add support for Markdown editing wherever we can, because people like Markdown and they should. It makes things simple and guarantees a certain level of flexibility for their writing far beyond the standards of twitter-like systems with tiny little text boxes. If you don't really support Markdown people figure it out right away. But the character limits and stuff like that seem more technical to users. Markdown support says clearly -- you're really on the web."
It's time to do whatever you were sent here to do.