5 ms·
Does this support JOINs? Or do you use a giant WHERE IN () clause? My use case is essentially a cross-database JOIN that I've been using MySQL & temp tables to
by fletchowns 12y ago
Does this support JOINs? Or do you use a giant WHERE IN () clause?
My use case is essentially a cross-database JOIN that I've been using MySQL & temp tables to accomplish. For example, give me the sum of column x if column y is any one of these 50,000 values from a separate system. So load the 50,000 values into a temp table and then do a JOIN. Performance isn't that great and it uses a ton of disk space so I wanted to try using a columnar store.
- techscruggs 12y agoSeems like you might want to consider getting all of your data in the same place. A Foreign Data Wrapper feeding a Materialized View might be a neat way to solve your problem: http://www.postgresql.org/docs/9.3/interactive/rules-materializedviews.html http://www.postgresql.org/docs/9.3/interactive/rules-materia...
- fletchowns 12y ago> Seems like you might want to consider getting all of your data in the same place Unfortunately that's not possible