cartero Thursday, August 13, 2026 · No. 25959
PostgreSQL

Radim Marek: TOAST: Where PostgreSQL hides big values

In earlier posts in this series we established that every heap tuple lives inside a strict 8KB page. Everything else is built on top of that hard limit: MVCC, HOT updates, and indexes that point at (page, line_pointer). And yet this still works: CREATE TABLE docs (id int PRIMARY KEY, body jsonb); INSERT INTO docs VALUES (1, (SELECT jsonb_agg(g) FROM generate_series(1, 100000) g)); That body value is somewhere north of half a megabyte. The heap page is still 8KB. Both statements are true at th...

Query Planning

Andrei Lepikhov: On Polymorphic Associations in Postgres

OUTER JOIN is a typical plague of ORM-based PostgreSQL configurations: the planner is still relatively poor at optimising it. At the same time, ORM frameworks — and 1C as a prominent example — often generate outer joins from standard templates, which opens the door to targeted optimisations. In this article, I dig into one such template — polymorphic reference resolution: what the pattern is, where it comes from (Rails, Django, Hibernate, Salesforce — not just 1C), how widespread it i...

Microsoft

Limerick

Rust

Minimal cross-platform direct I/O abstraction for Rust.

Just published my first Rust crate: odirect It’s a small cross-platform library for opening files with direct/unbuffered I/O. Linux → O_DIRECT macOS → F_NOCACHE Windows → FILE_FLAG_NO_BUFFERING https://crates.io/crates/odirect https://github.com/ankushT369/odirect submitted by /u/ankush2324235 [link] [comments]

MySQL

Migrating Etsy’s database sharding to Vitess

Etsy has maintained a sharded MySQL architecture since around 2010. This database cluster contains most of Etsy’s online data and is made up of ~1,000 tables distributed across ~1,000 shards. Over the last 16 years, it has grown significantly: combined, these tables have over 425 TB of data and receive roughly 1.7 million requests per second. Etsy engineers access our MySQL data through a proprietary object-relational mapping (ORM). The ORM has a corresponding model for each MySQL table. W...

Artificial Intelligence

Making Ads Count: Using MMoE and Auxiliary Tasks to Better Connect Buyers & Sellers

When buyers search on Etsy, they need to quickly and easily find the perfect item. At the same time, sellers need to be confident their unique products are being seen by the right customers. Our Ads Search ranking model, which is built on a multitask learning foundation, is the critical link in this connection. Recently, we identified an opportunity to drive more meaningful buyer engagement by enhancing our model’s ability to predict purchase intent. We achieved this via a dual-pronged impr...

Build Systems

NeuralNote

C++

wake up! 16b

JavaScript and TypeScript

Bun.Image

Exploit Development

Pardon MIE?

Caching Strategies

Userspace cache library

So I am writing a cross platform library in rust where I want to have a cache in userspace and it will directly read data from disk bypassing the OS page cache. Can you guys tell me what cache data structure should I use because in case of LRU cache we use linked list but the problem is each node's memory is separated so a lot of page fault. I want to know what cache modern databases use. submitted by /u/ankush2324235 [link] [comments]