Re: proposal: Allocate work_mem From Pool - Mailing list pgsql-hackers

From Joseph D Wagner
Subject Re: proposal: Allocate work_mem From Pool
Date
Msg-id 1ac57119a27c557743bd5f3e24c0ef1c@josephdwagner.info
Whole thread Raw
In response to Re: proposal: Allocate work_mem From Pool  (John Naylor <john.naylor@enterprisedb.com>)
Responses Re: proposal: Allocate work_mem From Pool
List pgsql-hackers
>> Before I try to answer that, I need to know how the scheduler works.

> As I understand the term used, there is no scheduler inside Postgres
> for user connections -- they're handled by the OS kernel.

Then, I'm probably using the wrong term. Right now, I have
max_worker_processes set to 16. What happens when query #17
wants some work done? What do you call the thing that handles
that? What is its algorithm for allocating work to the processes?
Or am I completely misunderstanding the role worker processes
play in execution?

Joseph Wagner



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: POC: GROUP BY optimization
Next
From: Dilip Kumar
Date:
Subject: Re: making relfilenodes 56 bits