Re: BUG #6629: Creating a gist index fails with "too many LWLocks taken"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #6629: Creating a gist index fails with "too many LWLocks taken"
Дата
Msg-id 3642.1336745965@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #6629: Creating a gist index fails with "too many LWLocks taken"  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: BUG #6629: Creating a gist index fails with "too many LWLocks taken"
Список pgsql-bugs
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> On 11.05.2012 16:52, Tom Lane wrote:
>> IMO, no part of the system should ever get within an order of magnitude
>> of holding 100 LWLocks concurrently.

> I agree we should never get anywhere near that limit. But if we do -
> because of another bug like this one - it would be nice if it was just
> an ERROR, instead of a PANIC.

By the time you hit that limit, you have already got a problem that
should never have gotten into the field, I think.  Simon's idea of
logging a warning once we get beyond a sane number of LWLocks seems like
it might be helpful towards finding such problems earlier; though I'd
put the "sane" limit at maybe 20 or so.  Perhaps it'd be useful to
measure what the max length of that list is during the regression tests.

            regards, tom lane

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: BUG #6624: Tab completion of identifier containing single backslash triggers warnings
Следующее
От: Robert Haas
Дата:
Сообщение: Re: BUG #6629: Creating a gist index fails with "too many LWLocks taken"