News for hackers. Stuff that matters.

A comment on Using PostgreSQL as a Data Warehouse. Parent comment

Re:Using PostgreSQL as a Data Warehouse by flakiness on Monday May 10, 2021 @10:47PM (#27113673)
A full scan rarely happens on BQ because of the nature of the columnar store. Try some public dataset like HN archive, and see how a query actually costs. You'll need very advanced (or stupid) query to read 100GB at once on BQ.
[ Parent | on HN ]

There are no comments on this comment yet.