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 h
's a max of 8 worker process, and 12 queries trying to run.
When does query #9 run? After the first of 1-8 completes, simple FIFO?
Or something else?
Also, how long goes a query hold a worker process? All the way to
completion? Or does is perform some unit of work and rotate to
another query?
out the maximum that
will be used.
Thoughts?
Thank you for your time.
Joseph D. Wagner
My specifics:
-64 GB box
-16 GB shared buffer, although queries only using about 12 GB of that
-16 GB effective cache
-2-3 GB used by OS and apps
-the rest is available for Postgresql queries/connections/whatever as
needed
