Postgres Just Cracked the Top Fastest Databases for Analytics

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by atombender on Saturday March 08, 2025 @09:00AM (#43300315)

Your comment is confusing to me because it appears to have nothing to do with the article, which is not about using Postgres' heap tables. In fact, you're arguing for a purpose-built storage engine (BigQuery), which is what pg_mooncake also is, except the latter is integrated with Postgres.

At my company we self-host ClickHouse, but if we started out today we'd definitely adopt ClickHouse Cloud. One big advantage of CH is that tables can be backed by ordinary cloud storage like S3 and GCS, which is incredibly cheap. BQ has support for external Iceberg tables in GCS, but (from what I recall) no write support.

We are shuffling several TBs/week into BigQuery, and that is extremely expensive. Querying this amount of data (billions of rows per day) is also very expensive unless you purchase flat pricing.

If your needs are really modest, then BQ is definitely very reasonable.

[ Parent | on HN ]

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by bhouston on Saturday March 08, 2025 @12:49PM (#43301959)

I will investigate Clickhouse. It is probably an even better solution that BigQuery when you have a lot of data and have a lot of queries.

[ Parent | on HN ]

Re:Postgres Just Cracked the Top Fastest Databases for Analy... by atombender on Saturday March 08, 2025 @04:03PM (#43303491)

Clickhouse is amazing. So is Postgres, but CH excels at its particular use case where Postgres does not.

While these new Postgres extensions will make Postgres more competitive, CH is built from the ground up for these kinds of analytics workloads in a way that Postgres isn't, e.g. in terms of scalable data ingestion.

CH also has a rich set of features like materialized views, aggregate function types, and dictionaries, none of which have counterparts in Postgres of these extensions.

[ Parent | on HN ]