Writing a Postgres Foreign Data Wrapper for Clickhouse in Go

Re:Writing a Postgres Foreign Data Wrapper for Clickhouse in Go by arunk-s on Friday November 20, 2020 @12:44AM (#25157642)

Hi, Author here.

I have to admit, I haven't done any benchmarking against the existing FDWs for Clickhouse. But I actually wrote the Go FDW 2 years ago(around Dec 2018). ;)

There weren't any Clickhouse FDW available at that time and I probably would've tried them as well.

Now I just got around to write the blog post and convincing the team to release the code.

Though I have a suspicion that the percona FDW might win in the benchmarks as they won't have to pay the penalties when crossing the Go land to C land.[1]

1: https://www.cockroachlabs.com/blog/the-cost-and-complexity-o...

[ Parent | on HN ]

Re:Writing a Postgres Foreign Data Wrapper for Clickhouse in Go by tristor on Friday November 20, 2020 @01:45AM (#25157873)

Thanks for the reply. I really appreciate your post and the additional FDW. If you ever decide to give it a go, a benchmark would be interesting, if for no other reason than to see how much penalty cgo actually incurs vs possible efficiency gains in your implementation strategy.

[ Parent | on HN ]

Re:Writing a Postgres Foreign Data Wrapper for Clickhouse in Go by arunk-s on Friday November 20, 2020 @02:53AM (#25158214)

Yes for sure. Definitely a benchmark would be a very solid approach to see the efficiency differences.

[ Parent | on HN ]