Amateur here. I have a couple of the same old 4 core computers that I am trying to use to beef up some automatic query scripts that run every evening for my hobby. I recently found MPICH to have the two computers communicate with each other. I also found documentstion that allows postresql to use more than the default number of cores (It was set at 2). I am hoping there is some way of being able to use all 8 cores to run some SQL queries. Is this possible? Any thoughts or recommendations are appreciated.
4
-
Check Postgres-XL.– ypercubeᵀᴹSep 27, 2019 at 20:39
-
1@ypercubeᵀᴹ setting up this beast on "a couple of the same old 4 core computers" might become a full-scale hobby in itself, don't you think?– mustaccioSep 27, 2019 at 21:14
-
@mustaccio sounds kinda cool to me! Better that than being mindlessly sat in front of a television or drinking yourself silly every evening! To the OP, come back if you have problems! p.s. welcome to the forum! :-)– VéraceSep 28, 2019 at 3:50
-
@mustaccio you are absolutely right but it does answer the question. If I posted an answer, there would be a notice or something about the extra work needed (compared to a Postgres installation).– ypercubeᵀᴹSep 28, 2019 at 9:42
Add a comment
|
1 Answer
If you want a solution using plain PostgreSQL, you will have to use sharding, that is, you will have to split the database into parts that you keep on different machines.
You can use PL/Proxy to have a single query run on all machines in parallel.
answered Sep 28, 2019 at 7:46
