News for hackers. Stuff that matters.

metdos

Curious if you have better pointers to understand the fundamentals of the field?
Re:Columnar Store for Analytics with Postgres on Thursday October 12, 2017 @10:55AM (#15458405)
If you have a common filter, it is a good idea to sort your data on that field and load into cstore_fdw. This will help to use skip indexes. https://github.com/citusdata/cstore_fdw#using-skip-indexes
Re:Columnar Store for Analytics with Postgres on Thursday October 12, 2017 @10:52AM (#15458378)
This actually depends on your use case and type of your queries. There is a blog post (2014) about a benchmark: https://www.citusdata.com/blog/2014/06/14/columnar-store-ben...

I also believe that the main use case is for the compression of data more than the performance benefits.

Re:How I'm Predicting Baseball Outcomes on Wednesday May 15, 2013 @11:13AM (#5712500)
Not baseball, but for the college football http://winningformula.espn.com/
Re:Run SQL on MongoDB on Wednesday October 17, 2012 @09:59AM (#4664430)
Why not? It may be useful to people who already have their data in MongoDB and don't want to migrate their data to an RDBMS.
Re:What Happens to Stolen Bicycles? on Wednesday August 29, 2012 @06:44AM (#4447901)
Even though I locked it, my bicycle also was stolen in Barcelona in 15 minutes in middle of city.