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:
- Database (probably relational)
- Analytics oriented (no updates\deletes are required)
- Fast (like using a tableau extract)
- Supports SQL queries
- Preferably open-source
- 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.