Postgres with data branching and PII anonymization

#1

Post by simonklee » Thu, May 15, 2025, 8:14 AM UTC

Postgres with data branching and PII anonymization
xata.io

Re: Postgres with data branching and PII anonymization

#2

Post by simonklee » Thu, May 15, 2025, 8:33 AM UTC

Performance benefits of the approach seem nice, with SPDK reducing kernel context switches, and direct NVMe to reduce latency in the storage path. This does require a more specialized setup, than Neon's tiered architecture (Safekeepers → Pageservers → cloud storage), at the expense of storage cost obviously.

Re: Postgres with data branching and PII anonymization

#3

Post by tudorg » Sun, May 18, 2025, 10:44 AM UTC

There's another thread here: https://news.ycombinator.com/item?id=44016289

Might make sense to merge.

Re: Postgres with data branching and PII anonymization

#4

Post by thulasi503 » Sun, May 18, 2025, 10:52 AM UTC

If you don't mind me asking I'm curious, what tool did you use for the diagrams?

Re: Postgres with data branching and PII anonymization

#5

Post by tudorg » Sun, May 18, 2025, 10:54 AM UTC

thulasi503 wrote: post #4

If you don't mind me asking I'm curious, what tool did you use for the diagrams?

[author] Ha, they are actually react-flow, which we use both in the app and on https://xata.io/

For the blog post I actually just used screenshots of the react-flow diagrams, because I was lazy.