Hacker News: saisrirampur

Can Postgres survive a bad query?

saisrirampur — Tue, 13 Oct 2026 01:57:22 +0000

Article URL: https://clickhouse.com/blog/can-your-postgres-survive-a-bad-query

Comments URL: https://news.ycombinator.com/item?id=50065624

Points: 1

# Comments: 0

New comment by saisrirampur in "Postgres isn't slow, your storage is"

saisrirampur — Mon, 12 Oct 2026 16:56:53 +0000

Stay tuned, you’ll hear something from us soon!

New comment by saisrirampur in "Postgres isn't slow, your storage is"

saisrirampur — Mon, 12 Oct 2026 16:54:24 +0000

Agreed. This is probably the trickiest part of building managed Postgres on local NVMe. Postgres already gives you a lot of the building blocks: physical streaming replication, synchronous replication, WAL archiving/PITR with backup toold, etc. The hard part is making failovers, recovery, and node replacements seamless.

We’ve spent a fair bit of time on this at ClickHouse through our operational expertise huilding Postgres managed services multiple times. We’re fortunate to have deep internal and partner Postgres expertise, folks who originally built WAL-G back in the Citus Data days and are active contributors now and solid partnership with Ubicloud.

It’s definitely more engineering work, but the performance/scalability gains make it worth it. Relaying this based on 100s of customers who migrated to ClickHouse Managed Postgres - new, powerful world surpassing previous expectations.

Postgres isn't slow, your storage is

saisrirampur — Mon, 12 Oct 2026 06:36:53 +0000

Article URL: https://clickhouse.com/blog/posette-talk-recap-postgres-isnt-slow-your-storage-is

Comments URL: https://news.ycombinator.com/item?id=50052163

Points: 175

# Comments: 185

ClickHouse C – Talk to ClickHouse using its native binary protocol

saisrirampur — Sun, 11 Oct 2026 23:08:29 +0000

Article URL: https://github.com/ClickHouse/clickhouse-c

Comments URL: https://news.ycombinator.com/item?id=50049003

Points: 48

# Comments: 3

Postgres FDW: Pushdown is a negotiation

saisrirampur — Sun, 11 Oct 2026 22:54:04 +0000

Article URL: https://clickhouse.com/blog/postgres-fdw-pushdown-negotiation

Comments URL: https://news.ycombinator.com/item?id=50048857

Points: 2

# Comments: 0

How we migrated Clera's 500 GB production Postgres database overnight

saisrirampur — Sat, 10 Oct 2026 17:45:40 +0000

Article URL: https://www.getclera.com/blog/how-we-migrated-to-clickhouse-managed-postgres

Comments URL: https://news.ycombinator.com/item?id=50035288

Points: 1

# Comments: 0

Postgres isn't slow your storage is

saisrirampur — Tue, 06 Oct 2026 21:01:12 +0000

Article URL: https://clickhouse.com/blog/posette-talk-recap-postgres-isnt-slow-your-storage-is

Comments URL: https://news.ycombinator.com/item?id=49984087

Points: 3

# Comments: 1

Postgres 19: What's New with Monitoring?

saisrirampur — Sat, 03 Oct 2026 22:59:21 +0000

Article URL: https://clickhouse.com/blog/postgres-19-monitoring-whats-new

Comments URL: https://news.ycombinator.com/item?id=49948601

Points: 3

# Comments: 0

Memory safety for Postgres extensions in C/C++

saisrirampur — Sat, 03 Oct 2026 15:16:59 +0000

Article URL: https://clickhouse.com/blog/memory-safety-postgres-extensions-c-cpp

Comments URL: https://news.ycombinator.com/item?id=49945038

Points: 1

# Comments: 0

Can your Postgres survive a bad query?

saisrirampur — Fri, 02 Oct 2026 01:37:47 +0000

Article URL: https://clickhouse.com/blog/can-your-postgres-survive-a-bad-query

Comments URL: https://news.ycombinator.com/item?id=49929006

Points: 2

# Comments: 0

Can your Postgres survive a bad query?

saisrirampur — Tue, 29 Sep 2026 14:54:25 +0000

Article URL: https://clickhouse.com/blog/can-your-postgres-survive-a-bad-query

Comments URL: https://news.ycombinator.com/item?id=49894396

Points: 1

# Comments: 0

Can your Postgres survive a bad query?

saisrirampur — Mon, 28 Sep 2026 17:25:59 +0000

Article URL: https://clickhouse.com/blog/can-your-postgres-survive-a-bad-query

Comments URL: https://news.ycombinator.com/item?id=49881390

Points: 3

# Comments: 0

PostgreSQL and the Linux OOM Killer: A Better Default

saisrirampur — Sun, 27 Sep 2026 01:11:49 +0000

Article URL: https://clickhouse.com/blog/strict-memory-overcommit-for-postgres

Comments URL: https://news.ycombinator.com/item?id=49862319

Points: 2

# Comments: 0

Pg_chdb, fast imports from object storage to Postgres using COPY

saisrirampur — Wed, 23 Sep 2026 05:07:45 +0000

Article URL: https://github.com/ClickHouse/pg_chdb

Comments URL: https://news.ycombinator.com/item?id=49811883

Points: 1

# Comments: 0

Postgres 19: What's new in monitoring?

saisrirampur — Mon, 21 Sep 2026 05:59:37 +0000

Article URL: https://clickhouse.com/blog/postgres-19-monitoring-whats-new

Comments URL: https://news.ycombinator.com/item?id=49783513

Points: 2

# Comments: 0

Show HN: Pg_chdb, fast imports from object storage to Postgres using COPY

saisrirampur — Sat, 19 Sep 2026 17:42:09 +0000

Article URL: https://clickhouse.com/blog/introducing-chdb-postgres

Comments URL: https://news.ycombinator.com/item?id=49768601

Points: 4

# Comments: 0

New comment by saisrirampur in "WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL"

saisrirampur — Thu, 17 Sep 2026 02:30:03 +0000

Right, it takes some effort, but it’s worth it for the benefits of sub-second latency and reduced operational overhead. We expect the WAL format for existing commands to remain relatively stable across Postgres versions, while newer commands may need additional handling.

New comment by saisrirampur in "WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL"

saisrirampur — Thu, 17 Sep 2026 02:27:31 +0000

WalShadow requires direct access to the physical WAL, and most managed Postgres providers don't allow that. It works with ClickHouse Managed Postgres or self-hosted Postgres. I talk about this in the blog:

Physical WAL is key to WalShadow’s architecture, but most managed Postgres services don’t expose it to customers, making it impossible to use WalShadow. ClickHouse Managed Postgres manages both sides of the stack, allowing us to integrate WalShadow directly into the Postgres replication layer and provide a native path from Postgres WAL to ClickHouse.

New comment by saisrirampur in "WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL"

saisrirampur — Wed, 16 Sep 2026 21:35:13 +0000

Ack, thank you! The idea was to minimize the operational overhead of logical replication (slot growth, slowdowns from reorder buffering, handling advance schema changes) and reducing load on Postgres. This approach lets us purpose-build replication for ClickHouse. Postgres logical replication was primarily designed keeping in mind with Postgres as the target.

There’s also some interesting work happening in core with a similar goal of decoupling logical decoding from the Postgres process. We plan to share learnings from WalShadow with the core and hopefully help bring this to Postgres someday :) https://hacking.postgres.tv/topics/logical-decoding/