Hello,
we are trying to experiment with AlloyDB for a new project. we created a table and while trying to load it into the columnar engine get this error:
SELECT google_columnar_engine_add('lineorder_flat_y1992');
WARNING: Out of memory while allocating memory
google_columnar_engine_add
----------------------------
0
(1 row)
we think we know what the error means - the table could not fit in memory but that is to be expected. we will have tables big enough that they cannot fit in memory. in fact in above we are not even loading the full table, just a partition and it already bails out. So can the column store of AlloyDB only handle tables that fit in its memory? How is this practical for real use-case? We can't keep increasing RAM size to accommodate ever increasing datasets.
LinkedIn
Twitter
