Developer news without the noise — My Dev News in Telegram.

Open botLearn more
Stuzhuk Lab

Stuzhuk Lab — Chemistry of Code

Chemistry of Code

  • Home
  • Portfolio
  • Services
  • Blog
  • Contact
  • Sign in
  • 🇬🇧
    🇷🇺🇺🇦
← All posts

Tag

postgresql

All blog posts with this tag.

  • 24 Oct 2026

    Optimizing Huge Databases: SQL, Indexes, Schema, and Architecture at Billions of Rows

    A practical reference for large databases: plan diagnostics, queries, indexes, EAV in ERP, partitions, locking, caching, and scaling for PostgreSQL, SQL Server, and MySQL, without the "just buy SSDs" myth.

    architectureBackenddatabaseerpmysqlPerformancepostgresqlsql server
  • 23 Oct 2026

    PlanetScale Neki shard groups: design from queries, not from your table list

    How shard groups co-locate related rows in sharded Postgres (Neki): query-first design, reference tables, Reshard, and hashing algorithms.

    DatabasesNewsPerformancepostgresql
  • 12 Sept 2026

    Two servers and a witness: high availability for Totum

    How a Totum install moved to two main servers plus a small witness: database failover, files, and a health check.

    Newsinfrastructurepostgresql

We store small technical data in your browser (theme, typing progress, reading history) and cookies for language/session. Not ad tracking.