Why no benchmarks against pg_vector, DuckDB with extension?
For benchmarks you may just prepare Phoronix Test Suite module (https://www.phoronix-test-suite.com/) to facilitate replication on a variety of machines.
Unfortunately the default configuration poses significant security problems, allowing for sidestepping 2-factor authentication schemes, and sideloading of applications without user permission (!)
Oh, lord yes! Frequently they're scraping us from multiple distinct CIDR blocks simultaneously. But we can tell it's the same organization doing it not just because the requests look similar, but it's even possible occasionally to see a request for a search from one CIDR that's followed up immediately by requests for details for the products that had been returned by the search.
While at the same time, because our site is B2B ecommerce, where our typical customer is a decent-sized corporation, it's not uncommon for a single legit user to have consecutive requests originate from different IPs, as their internal proxies use different egress points.
except real life performance is not about nm process (this is almost completely irrelevant) or benchmarks.
I load my DuckDB into RAM and I'm mindblown at the speed that I can run data analysis on it due to RAM bandwidth and the fact that it's SoC, so almost no bottleneck between RAM and the CPU. Dozens of seconds on a $5k PC compared to milliseconds on a $2k Mac.
Not to mention that Windows 11 is a very weird OS.
Linux is great for some usecases, but doesn't utilize the hardware in the same way as other OSs.
I have all OSs at home and the difference is stupendous.
If the task takes "dozens of seconds" on the PC, there is no way it is shortened to millisecond on the Mac. Unless you purposefully make it a bad comparison to favor the Mac.
While I admire social-network-friendly websites, I am afraid that performance is too bad to allow its use instead of a social network.
Indeed it is so performance sensitive, that it has blocked my region.
Would it not be better to get a static site generator from a standard Markdown posts, and thus assure it is both performant and accessible?
For benchmarks you may just prepare Phoronix Test Suite module (https://www.phoronix-test-suite.com/) to facilitate replication on a variety of machines.