Re: Parallel Execution of Query

Поиск
Список
Период
Сортировка
От Shmagi Kavtaradze
Тема Re: Parallel Execution of Query
Дата
Msg-id CAHY6maxyP2uPDdXHpb0dXoSqyiab8xuSzsPUoocmcJF+UZb18A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Parallel Execution of Query  (James Keener <jim@jimkeener.com>)
Ответы Re: Parallel Execution of Query
Список pgsql-novice
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?


В списке pgsql-novice по дате отправления:

Предыдущее
От: James Keener
Дата:
Сообщение: Re: Parallel Execution of Query
Следующее
От: James Keener
Дата:
Сообщение: Re: Parallel Execution of Query