15 ms·
Pgsql: Create an infrastructure for parallel computation in PostgreSQL
- nattaylor 11y agoLots more info in the README http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=924bcf4f16d54c55310b28f77686608684734f42#patch4 http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitd...
- anilshanbhag 11y agoCan someone explain to me (and others) a potential usecase for this ?
- amitlan 11y agoIntra-query parallelism for starters.
- brentadamson 11y agothat clears it up. thx
- deleted 11y ago[deleted]
- no1youknowz 11y agoWill this be compatible with say pg_shard? Does anyone know how this stacks up against CitusDB? Is the target for Postgres to natively do what CitusDB does right now?
- Jweb_Guru 11y agoThis is about parallelism on a single machine.
- no1youknowz 11y agoThanks for clearing that up.
- onderkalaci 11y agoAre there any examples how to use this feature?
- amitlan 11y agoNote that this in itself is not a feature but part of the infrastructure for developing parallel execution nodes (for an example, you could take a look at parallel seq scan under development[1]) EDIT: [1] is a huge discussion, by the way. [1] http://www.postgresql.org/message-id/CAA4eK1KTv73uD9_W5wR4HiMZ_hgi8oseWncxbC53XwZDp-8aEg@mail.gmail.com http://www.postgresql.org/message-id/CAA4eK1KTv73uD9_W5wR4Hi...
- onderkalaci 11y agoThanks for the reply. Then, my question becomes as follows: Is there a way for basic PostgreSQL users (as me) benefit from this (yet)? I don't want to dive into any codes :)
- JonnieCache 11y agoIt's a framework for future functionality. End-users won't be touching it for some time I expect. The best thing about psql is their careful, iterative engineering.
- amitlan 11y agoWe might see parallel seqscan soon.
- netghost 11y agoYeah, I think this is all under the hood, so in future releases, Postgres should perform even better for you ;)
- JoelJacobson 11y agoExciting! Back in 2013, I wrote this blog post [1], it's getting closer, but I should probably change the title to "Will PostgreSQL 9.6 Bring Back Moore’s Law?" [1] http://joelonsql.com/2013/04/20/will-postgresql-9-5-bring-back-moores-law/ http://joelonsql.com/2013/04/20/will-postgresql-9-5-bring-ba...
- talideon 11y agoThis is more of an Amdahl's Law thing though.