1

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. Commented 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?
    – mustaccio
    Commented Sep 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érace
    Commented Sep 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). Commented Sep 28, 2019 at 9:42

1 Answer 1

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.