Thanks for answer. What about async? can you tell in details?
On Mon, Nov 30, 2015 at 9:56 PM, James Keener <jim@jimkeener.com> wrote:
While parallel queries is an area of ongoing work, I do not believe that a single connection can currently use more than a single core. You could experiment with turning your 4000x4000 comparisons into 4 queries doing 2000x2000 comparison (assuming you have 4 cores available to the VM, the more cores, the more cores you could split it up) (just remember to use async for each of those so you don't execute them in serial!).
Jim
On 11/30/2015 12:00 PM, Shmagi Kavtaradze wrote: > I am doing similarity matching (cosine, euclidean). If I have 4000 > entries in a table, the number of comparisons will be 16M. I am running > postgres on a virtual machine, so it takes 20-25 minutes to run the > query or the system crashes. Can I run the query in parallel? I heard > there are tools like PL/Proxy and pgpool, can I use them to create > several databases on the same machine and run query in parallel?