Re: open items for 9.4
От | Tom Lane |
---|---|
Тема | Re: open items for 9.4 |
Дата | |
Msg-id | 11026.1412022912@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: open items for 9.4 (Andres Freund <andres@2ndquadrant.com>) |
Ответы |
Re: open items for 9.4
|
Список | pgsql-hackers |
Andres Freund <andres@2ndquadrant.com> writes: > On 2014-09-29 16:16:38 -0400, Tom Lane wrote: >> I wonder why it's a fixed constant at all, and not something like >> "wal_buffers / 8". > Because that'd be horrible performancewise on a system with many > wal_buffers. There's several operations where all locks are checked in > sequence (to see whether there's any stragglers that need to finish > inserting) and even some where they're acquired concurrently (e.g. for > xlog switch, checkpoint and such). Hm. Well, if there are countervailing considerations as to how large is a good value, that makes it even less likely that it's sensible to expose it as a user tunable. A relevant analogy is that we don't expose a way to adjust the number of lock table partitions at runtime. regards, tom lane
В списке pgsql-hackers по дате отправления: