Login

u/tee-es-gee

pg_deltax (δx): Fast time-series extension for PostgreSQL
▲ 39 r/PostgreSQL

pg_deltax (δx): Fast time-series extension for PostgreSQL

Hi,

There's something I've been working on for a few months and wanted to share here:

pg_deltax, a fast time-series extension for PostgreSQL. Basically an Apache-licensed Timescale alternative.

I've started working on this project because I wanted a pure-OSS Postgres extensions for time-series. Then I got competitive on ClickBench and wanted to see how fast I can make it.

It’s very early days, but the benchmarks already look really good (see in the README).

It's still slower than analytics-focused DBs like clickhouse or duckdb, but actually not that far behind. Consider getting that kind of performance without ever having to take the data out of Postgres. This is the part that I'm most excited about.

github.com
u/tee-es-gee — 2 days ago
▲ 46 r/zfs

Hi!

I wanted to share something that I hope you'll find cool enough to be relevant here.

We're using ZFS zvols as storage for our Postgres service, in order to offer CoW branching and so that we can scale up to a large number of instances. Because we wanted to separate storage from compute, we've written a user-space implementation of NVMe-oF and used it to expose the zpool over the network.

This combines the benefits of ZFS with network attached storage. More details in the blog post.

u/tee-es-gee — 22 days ago