1
Measuring How Fast Your IIoT Queries Are Degrading (opens on the source site)
Stop waiting for the dashboard to get slow. Record latency against row count, fit the curve, and get a date when your query breaches its target.
#postgresql
11 posts · 4 companies · newest first
Curated view of this subject:Topic: Postgres48
From the web
2
Sizing Your IIoT Table Before You Deploy (opens on the source site)
A 20-byte sensor reading costs 95.6 on disk. Measure bytes per row, project 631 billion rows, and test your ingest ceiling before the schema review.
3
Knowing When Your Composite Index Earns Its Write Cost (opens on the source site)
Composite indexes charge every insert and pay back only some queries. Four steps to price both sides and audit the indexes you already run.
4
The Real Cost of a Single Insert in Postgres (opens on the source site)
PostgreSQL write amplification explained: why indexes multiply WAL volume, how to measure it on your tables, and four ways to reduce it without schema changes.
5
Three principles for building a vector platform at Thumbtack (opens on the source site)
Reusing what we already had, treating embeddings as data, and lowering the next team’s costToday, an ML engineer at Thumbtack can stand up production vector search without negotiating database access, building a custom ETL, or writing a query service. The team brings their choice of embedding model, the data, and the query; the platform handles what connects them. It took several iterations to get to this point. In this post we’ll walk through how we got there and the three principles that shaped what we built.A vector database stores high-dimensional numeric arrays (embeddings) and serves…
6
Why a 40-Year-Old Database Is Still Winning in the AI Era (opens on the source site)
Why Postgres wins in the AI era: 40 years of reliability, extensibility, and an open ecosystem. Agents need trusted foundations, not fragile architectures.
7
Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows (opens on the source site)
Cardinality is a consequence of how many dimensions you index your readings by. Here is where the curve bends, measured, and what you can do about it without leaving Postgres. Someone adds a firmware_ver column to the sensor table. It is one line of DDL, and it clears review in a minute. Two weeks later, the ingest job is missing its window, a dashboard query that used to return in milliseconds takes seconds, and the on-call engineer is digging through EXPLAIN output to work out when the planne
8
Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale (opens on the source site)
When PostgreSQL tables are still relatively small, most tasks seem straightforward. You can run queries without thinking too much about indexes, retention jobs are manageable, and even vacuum operations usually stay under control. But things change pretty quickly once tables start growing into hundreds of millions or billions of rows. At that scale, even simple […] The post Advanced Partitioning Strategies for PostgreSQL OLTP and Analytics Datasets at Scale appeared first on Severalnines.
9
Building High Availability PostgreSQL Clusters with Patroni and Other Integrated Approaches (opens on the source site)
In modern application stacks, downtime is a direct threat to business continuity, customer trust, and revenue. Regardless of whether it is an e-commerce platform, a fintech application, or a critical internal system, the expectation is 24/7 availability, underscoring the critical importance of High Availability (HA) and automated failover mechanisms within PostgreSQL clusters. HA ensures that […] The post Building High Availability PostgreSQL Clusters with Patroni and Other Integrated Approaches appeared first on Severalnines.
10
PostgreSQL 18 Upgrades for AI-Era Workloads and Operations (opens on the source site)
Today, we’re asking PostgreSQL to do more and more, like handling both transactions and analytics, powering huge SaaS platforms, managing event data, and even dipping into AI-related tasks like vector search. This intense pressure highlights some pain points: slow, unpredictable reads, rigid indexing, complex setups, and risky major upgrades. PostgreSQL 18 directly addresses these real-world […] The post PostgreSQL 18 Upgrades for AI-Era Workloads and Operations appeared first on Severalnines.
11
Book Review – Just Use Postgres! (opens on the source site)
Introduction My friend, Denis Magda, wrote a wonderful book called Just Use Postgres!, and I’m glad that I got the chance to read it. Audience This book is useful for any software developer who’s either using PostgreSQL or plans on using it because it covers a lot of features that are very useful for modern applications. No matter your level of seniority, you are definitely going to learn from Denis’ book. Content Just Use Postgres! has 402 pages, 3 parts, and 11 chapters. The first part is an introduction to PostgreSQL and... Read More The post Book Review – Just Use Postgres! appeared first…
11 shown