| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | Petr Jelinek <petr(at)2ndquadrant(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Josh berkus <josh(at)agliodbs(dot)com>, Peter Geoghegan <pg(at)heroku(dot)com>, Noah Misch <noah(at)leadboat(dot)com>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Rename max_parallel_degree? |
| Date: | 2016-06-03 04:33:02 |
| Message-ID: | a2fffd92-6e59-a4eb-dd85-c5865ebca1a0@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 6/3/16 12:21 AM, Petr Jelinek wrote:
> On 01/06/16 17:55, David G. Johnston wrote:
>> On Wed, Jun 1, 2016 at 11:45 AM, Petr Jelinek <petr(at)2ndquadrant(dot)com
>> <mailto:petr(at)2ndquadrant(dot)com>>wrote:
>>
>> That GUC also controls worker processes that are started by
>> extensions, not just ones that parallel query starts. This is btw
>> one thing I don't like at all about how the current limits work, the
>> parallel query will fight for workers with extensions because they
>> share the same limit.
>>
>>
>> Given that this models reality the GUC is doing its job. Now, maybe we
>> need additional knobs to give the end-user the ability to influence how
>> those fights will turn out.
>
> Agreed, my point is that I think we do need additional knob.
We need one knob to control how many process slots to create at server
start, and then a bunch of sliders to control how to allocate those
between regular connections, superuser connections, replication,
autovacuum, parallel workers, background workers (by tag/label/group),
and so on.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2016-06-03 05:06:08 | Re: Let file_fdw access COPY FROM PROGRAM |
| Previous Message | Craig Ringer | 2016-06-03 04:24:09 | Re: Statement timeout |