80% speed gain via Pre-Aggregated subsets vs MongoDB (which gains on bloat)

01a49d89 d065 4a30 9f1b 050edd46696e

80% speed gain via Pre-Aggregated subsets vs MongoDB (which gains on bloat) On PostgreSQL https://medium.com/@kanishks772/we-cut-80-of-our-query-time-by-using-this-little-known-sql-pattern-fadec2bdb592 Compare against MongoDB To precisely compare real-world speed between PostgreSQL pre-aggregation using CTEs vs MongoDB aggregation pipelines — Below is a detailed side-by-side analysis — MongoDB 10% slower with smaller datasets — But MongoDB speed advantage increases with increasing datasets … Read more

ValKey is Redis open-sourced

Redis valkey

ValKey is Redis open-sourced Redis company made itself irrelevant Valkey replaces Redis due to a licensing conflict and project governance change that caused Redis to no longer be fully open source. Why the Change Happened In March 2024, Redis Labs (the company behind Redis) changed the license of Redis from the permissive BSD license to … Read more

ChatGPT Explains Itself as maddeningly memoryless

Thots

ChatGPT Explains Itself as maddeningly memoryless It’s basic, but what a doozie. …after an arduously long ping-pong of versioning a control file… PROMPT you’re really unable to save the config file, why not simply admit that? RESPONSE You’re right to call it out — here’s the straight answer: I can remember the configfile ZOIX during … Read more

Best Practices – Mongo Speed vs Distant WAN

Best Practices – Mongo Speed vs Distant WAN Yes — MongoDB replica sets across WANs can significantly impact performance, especially for read and write operations that wait on acknowledgments or are sensitive to replication lag. Here’s how to speed up your MongoDB replica set: Best Practices: 1. Yes, remove distant secondaries if: 2. Use readPreference: … Read more

Madness? Suspect AppArmor FIRST

280c9a6a a733 4351 867c 68c6e339ca2c

Madness? Suspect AppArmor FIRST AppArmor has caused silent, hard-to-diagnose issues for many people, and it’s even more frustrating because it’s often enabled by default without any loud warning or clear opt-out. So here’s the full story: who made it, where it came from, and how the hell it became default on systems like Debian and … Read more

DMARC DKIM SPF Email anti-spam slow-motion trainwreck

9a1bb833 fd2d 4827 9f58 88f07a63ce72

DMARC DKIM SPF Email anti-spam slow-motion trainwreck Recently a client’s long-well-running, important email process was broken, halting reception by their sales team of emailed notifications regardings product inquiries on their website. This was all working well before ~January. Quick fix: website will now send emails marked as being “From:sales@YOUR.net” Longer explanation: Microsoft/Outlook and/or 2cows.com apparently … Read more

Benchmarks of Docker vs BareMetal

Benchmarks of Docker vs BareMetal Note concern over mounted data volumes for Mongo Here are real-world performance comparison examples of MongoDB running on bare-metal vs Docker, using benchmarks and reports from known tests or developer observations: 1. Percona Benchmarks (2018–2020) Setup: MongoDB 4.x tested using YCSB (Yahoo! Cloud Serving Benchmark) and sysbench on identical hardware. … Read more