News for hackers. Stuff that matters.
Re:Faster PostgresSQL to BigQuery by marklit on Tuesday January 10, 2023 @07:22AM (#34323718)
I'll take a look into it.

Last year I found ClickHouse did H3 enrichment much faster than PG or BQ so it has become a go-between for larger workloads with simple enrichment requirements.

The dataset in the post is an example anyone can download. I handle 30B+ records at work.

Re:Faster PostgresSQL to BigQuery by qoega on Tuesday January 10, 2023 @11:45AM (#34327567)
>It would also be good to see GEOS, GDAL and PROJ integrated into ClickHouse.

You can just add feature requests like this to ClickHouse issue tracker. https://github.com/ClickHouse/ClickHouse/issues/45129

Re:Faster PostgresSQL to BigQuery by marklit on Tuesday January 10, 2023 @12:31PM (#34328374)