Re: reducing the overhead of frequent table locks, v4
От | Jeff Davis |
---|---|
Тема | Re: reducing the overhead of frequent table locks, v4 |
Дата | |
Msg-id | 1310490121.3012.274.camel@jdavis обсуждение исходный текст |
Ответ на | Re: reducing the overhead of frequent table locks, v4 (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: reducing the overhead of frequent table locks, v4
|
Список | pgsql-hackers |
On Tue, 2011-07-12 at 07:55 -0500, Robert Haas wrote: > I haven't been that worried about overflow of the fast path table. If > you are locking more than 16 relations at once, you probably have at > least 5 tables in the query, maybe more - it depends in how many > indexes you have, of course. My assumption has been that at that > point you're going to spend enough time planning and executing the > query that the lock manager will no longer be a major bottleneck. Of > course, there might be cases where that isn't so. Yeah, I think you're right here. It's probably not much of a practical concern. I was slightly bothered because it seemed a little unpredictable. But it seems very minor, and if we wanted to fix it later I think we could. Regards,Jeff Davis
В списке pgsql-hackers по дате отправления: