Top all-time · #6226
Severalnines
Company blog · severalnines.com/blogdatasystems
Severalnines is the company blog at severalnines.com, writing about data and systems. Since 2015, 12 different Hacker News readers have linked it 76 times, most often “My Favorite PostgreSQL Queries and Why They Matter”. It is still writing: the last post was on 2026-10-16, and you can follow it by feed.
Open-source and source-available database fleet automation in cloud, on-prem, and hybrid environments and self-hosted DBaaS platforms.
Most-linked posts?
- My Favorite PostgreSQL Queries and Why They Matter2 people · 2 mentions · first linked 2018-04-14
- Comparing Cloud Database Options for PostgreSQL2 people · 2 mentions · first linked 2018-05-01
- PostgreSQL Streaming Replication – A Deep Dive2 people · 2 mentions · first linked 2018-05-29
What Hacker News says?
> Edit: Possibly misinformed but the last deep dive we did indicated there was not a way to use logical replication for seamless upgrades. Will have to research. It is possible since PG10 https://severalnines.com/database-blog/how-upgrade-postgresq...
Comment linking /database-blog/how-upgrade-postgresql10-postgresql11-zero-downtime
on “PostgreSQL 14”Submitted My Favorite PostgreSQL Queries and Why They Matter as a story · 447 points
HN discussionThanks for the recommendation! And glad to hear TimescaleDB meets your needs. I wanted to add some color to hosting / deployment options around TimescaleDB. Options are as follows: [1] Fully-Managed TimescaleDB Enterprise on Timescale Cloud TimescaleDB Open Source hosted on Public Clouds: [2] Azure PostgreSQL [3] DO Managed-Postgres (mentioned above) [4] Alibaba Cloud Not hosted, but managed service options: [5] Clu…
Comment linking /blog/advanced-database-monitoring-management-timescaledb
on “Building a distributed time-series database on PostgreSQL”Submitted A Performance Cheat Sheet for PostgreSQL as a story · 172 points
HN discussionIt's not precisely "self modifying code" but FYI various systems are starting to use LLVM to specialize code at runtime (aka "JIT"), including Postgres, which is written in old school C. In the case of Postgres, the code is modified to precisely work for the particular SQL expression and for the particular table schema. This magic is on by default , which means 100 million+ computers are doing this right now. 25-40%…
Comment linking /database-blog/overview-just-time-compilation-jit-postgresql
on “On self-modifying executables in Rust”Submitted Automation and management of open source databases in the cloud as a story · 21 points
HN discussion- Access logs: audit logging [0] - Throughput/latency: pg_stat_statements [1] or Prometheus' exporter [2] - Tracing: you probably don't have tons of microservices if you're shipping your database - A/B tests: aren't these frontend things? recording which version a user got is an INSERT - Auth: row-level security [3] and session variables - Tracing, shadow traffic: I don't think these are relevant in a "ship your dat…
Comment linking /blog/postgresql-audit-logging-best-practices
on “Skip the API, Ship Your Database”Submitted Architecture and Tuning of Memory in PostgreSQL Databases as a story · 4 points
HN discussionSubmitted How to Go into Production with MongoDB – Top Ten Tips as a story · 4 points
HN discussionSubmitted PostgreSQL Tuning: Key Things to Drive Performance as a story · 3 points
HN discussionSubmitted Integrating PostgreSQL with Authentication Systems as a story · 3 points
HN discussionSubmitted Understanding Deadlocks in MySQL and PostgreSQL as a story · 3 points
HN discussionSubmitted Comparing Cloud Database Options for PostgreSQL as a story · 3 points
HN discussionSubmitted Become a MySQL DBA Blog Series – The Query Tuning Process as a story · 3 points
HN discussionSubmitted Schema Management Tips for MySQL and MariaDB as a story · 2 points
HN discussionSubmitted Tuning Input/Output (I/O) Operations for PostgreSQL as a story · 2 points
HN discussionSubmitted Multi Datacenter Setups with PostgreSQL as a story · 2 points
HN discussionSubmitted PostgreSQL Streaming Replication – A Deep Dive as a story · 2 points
HN discussionSubmitted Cloud Disaster Recovery for MariaDB and MySQL as a story · 2 points
HN discussionSubmitted An Overview of the Serial Pseudo-Datatype for PostgreSQL as a story · 2 points
HN discussionSubmitted Cloud Database Features Comparison – Amazon RDS vs. Google Cloud SQL as a story · 2 points
HN discussionSubmitted An Overview of Database Indexing for MongoDB as a story · 2 points
HN discussionSubmitted A Guide to Pgpool for PostgreSQL – Part One as a story · 2 points
HN discussionSubmitted Ten Tips for Going into Production with PostgreSQL as a story · 2 points
HN discussionSubmitted ClusterControl 1.2.11 for MySQL, MongoDB and PostgreSQL Released as a story · 2 points
HN discussionSubmitted Become a MySQL DBA – Deep Dive SQL Workload Analysis Using Pt-Query-digest as a story · 2 points
HN discussionSubmitted Webinar: Disaster Recovery Planning for MySQL and MariaDB with ClusterControl as a story · 1 points
HN discussionSubmitted How to Improve Performance of Galera Cluster for MySQL or MariaDB as a story · 1 points
HN discussionSubmitted Webinar Replay: Our Guide to MySQL and MariaDB Performance Tuning as a story · 1 points
HN discussionSubmitted MySQL on Docker: Running a MariaDB Galera Cluster Without Orchestration Tools as a story · 1 points
HN discussion
