4 ms·
From today's release notes (https://cloud.google.com/bigquery/docs/release-notes#july_25_2018 https://cloud.google.com/bigquery/docs/release-notes#july_25...):
by havermeyer 8y ago
From today's release notes (https://cloud.google.com/bigquery/docs/release-notes#july_25_2018 https://cloud.google.com/bigquery/docs/release-notes#july_25...):
> BigQuery has achieved approximately 5x improvement in TPC-DS 10T power run geomean over the past 18 months.
Outside of that, BigQuery now provides better partitioned table functionality (https://cloud.google.com/bigquery/docs/partitioned-tables https://cloud.google.com/bigquery/docs/partitioned-tables) as well as clustering (https://cloud.google.com/bigquery/docs/clustered-tables https://cloud.google.com/bigquery/docs/clustered-tables), both of which can help to reduce costs and improve performance. In terms of pricing, many large customers have reserved slots (https://cloud.google.com/bigquery/docs/slots https://cloud.google.com/bigquery/docs/slots), where you pay a fixed monthly cost in exchange for dedicated resources, similar to running a large Redshift instance.
As a disclosure, I work on the BigQuery team.