DB with column store and parallel query execution?
I am looking for open-source alternatives to SQL Server Enterprise Edition for a mostly-read analytics workload. The main key features that I'm looking for are
- Column-oriented storage
- Parallel query execution - in particular, sorts/group by etc. should use multiple cores, like SQL Server does.
- Clustering / horizontal scaling options. I am not interested in sharding or shared-nothing as much as I am in being able to add additional CPUs to a single (logical) DB instance.
I looked at PostgreSQL with cstore_fdw, which gets a column-store but individual queries are still single-threaded.
What else should I be looking at?
parallelism columnstore
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I am looking for open-source alternatives to SQL Server Enterprise Edition for a mostly-read analytics workload. The main key features that I'm looking for are
- Column-oriented storage
- Parallel query execution - in particular, sorts/group by etc. should use multiple cores, like SQL Server does.
- Clustering / horizontal scaling options. I am not interested in sharding or shared-nothing as much as I am in being able to add additional CPUs to a single (logical) DB instance.
I looked at PostgreSQL with cstore_fdw, which gets a column-store but individual queries are still single-threaded.
What else should I be looking at?
parallelism columnstore
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Take a look at MonetDB or Vector (Actian)
– marcin_koss
Apr 1 '16 at 14:15
Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though.
– ypercubeᵀᴹ
Apr 6 '16 at 11:17
add a comment |
I am looking for open-source alternatives to SQL Server Enterprise Edition for a mostly-read analytics workload. The main key features that I'm looking for are
- Column-oriented storage
- Parallel query execution - in particular, sorts/group by etc. should use multiple cores, like SQL Server does.
- Clustering / horizontal scaling options. I am not interested in sharding or shared-nothing as much as I am in being able to add additional CPUs to a single (logical) DB instance.
I looked at PostgreSQL with cstore_fdw, which gets a column-store but individual queries are still single-threaded.
What else should I be looking at?
parallelism columnstore
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
I am looking for open-source alternatives to SQL Server Enterprise Edition for a mostly-read analytics workload. The main key features that I'm looking for are
- Column-oriented storage
- Parallel query execution - in particular, sorts/group by etc. should use multiple cores, like SQL Server does.
- Clustering / horizontal scaling options. I am not interested in sharding or shared-nothing as much as I am in being able to add additional CPUs to a single (logical) DB instance.
I looked at PostgreSQL with cstore_fdw, which gets a column-store but individual queries are still single-threaded.
What else should I be looking at?
parallelism columnstore
parallelism columnstore
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
asked Feb 9 '16 at 14:52
wrschneiderwrschneider
2293513
2293513
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Take a look at MonetDB or Vector (Actian)
– marcin_koss
Apr 1 '16 at 14:15
Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though.
– ypercubeᵀᴹ
Apr 6 '16 at 11:17
add a comment |
Take a look at MonetDB or Vector (Actian)
– marcin_koss
Apr 1 '16 at 14:15
Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though.
– ypercubeᵀᴹ
Apr 6 '16 at 11:17
Take a look at MonetDB or Vector (Actian)
– marcin_koss
Apr 1 '16 at 14:15
Take a look at MonetDB or Vector (Actian)
– marcin_koss
Apr 1 '16 at 14:15
Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though.
– ypercubeᵀᴹ
Apr 6 '16 at 11:17
Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though.
– ypercubeᵀᴹ
Apr 6 '16 at 11:17
add a comment |
1 Answer
1
active
oldest
votes
Depending on your queries, postgresql + citus + cstore_fdw may solve your problems. Citus (with sharding) can parallelize your queries, and cstore_fdw provides columnar storage.
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f128736%2fdb-with-column-store-and-parallel-query-execution%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Depending on your queries, postgresql + citus + cstore_fdw may solve your problems. Citus (with sharding) can parallelize your queries, and cstore_fdw provides columnar storage.
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
add a comment |
Depending on your queries, postgresql + citus + cstore_fdw may solve your problems. Citus (with sharding) can parallelize your queries, and cstore_fdw provides columnar storage.
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
add a comment |
Depending on your queries, postgresql + citus + cstore_fdw may solve your problems. Citus (with sharding) can parallelize your queries, and cstore_fdw provides columnar storage.
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
Depending on your queries, postgresql + citus + cstore_fdw may solve your problems. Citus (with sharding) can parallelize your queries, and cstore_fdw provides columnar storage.
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
answered Apr 6 '16 at 11:07
Murat TuncerMurat Tuncer
462
462
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f128736%2fdb-with-column-store-and-parallel-query-execution%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Take a look at MonetDB or Vector (Actian)
– marcin_koss
Apr 1 '16 at 14:15
Consider Postgres-XL as well. Needs more machines (in a cluster) to make use of it though.
– ypercubeᵀᴹ
Apr 6 '16 at 11:17