1
$\begingroup$

I'm analyzing a single large table (about 50GB 16M rows, 15 columns perhaps more) currently using PostgreSQL 9.4. Most of my queries doesn't involve more tables.

Queries run time are very large. I'm comparing it to similar queries in Tableau. I know this comparison is not fair, Tableau extract was designed for this usage. Nevertheless i think that i'm not the only one looking for such a solution.

What i'm looking for is:

  1. Database (probably relational)
  2. Analytics oriented (no updates\deletes are required)
  3. Fast (like using a tableau extract)
  4. Supports SQL queries
  5. Preferably open-source
  6. Will not require much optimization (i don't want to be responsible for indexes creation, like in Tableau extract creation)

To illustrate: if i had the ability to connect to a Tableau extract locally like to a localhost database and run SQL quires on it, this will be great.

$\endgroup$
  • $\begingroup$ I think you're looking for a columnar database. look at this wikipedia page for a list. $\endgroup$ – phiver Aug 8 '16 at 17:03
  • $\begingroup$ Can't you just install 64GB of RAM and push your table there? $\endgroup$ – Diego Aug 10 '16 at 23:53
  • $\begingroup$ Let's say i'm willing to install 64GB RAM, i'm looking for a DB\Soloution that will allow to easly "push" the table there. Currently i'm trying Oracle's "in_memory" option following @phiver's comment. $\endgroup$ – Guy s Aug 11 '16 at 6:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.