'Too many LWLocks held' with GIN pg_trgm_ops index [RE-SENT]

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема 'Too many LWLocks held' with GIN pg_trgm_ops index [RE-SENT]
Дата
Msg-id 480C4D2D.80601@postnewspapers.com.au
обсуждение исходный текст
Ответы Re: 'Too many LWLocks held' with GIN pg_trgm_ops index [RE-SENT]  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-bugs
[RESENT MESSAGE - the previous one was presumably held for moderation
because of an attachment. If the prior one did in fact make it through
and I just didn't get it then sorry for the noise.]

Hi all

Following my -general post about this issue I'm supplying a test case
for a query that fails with a 'Too many LWLocks held' error.

The test data, system configuration details, etc are in the tarball that
you can obtain here:

http://www.postnewspapers.com.au/~craig/lwlock_test.tar.bz2

The README in the package provides all the detail I can think of, but
here's the summary again:

------
This is a test case for a `Too many LWLocks held' error encountered when
using pg_trgm with a GIN index in the following query:

SELECT a.message, b.message FROM po_message a, po_message b
WHERE a.id <> b.id AND a.message % b.message;

The error does not occur if a GIST index is present on
`po_message.message' instead of a GIST index, or if no index is present
at all. It only arises when the % operator is used.
------

--
Craig Ringer

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

Предыдущее
От: "Buk"
Дата:
Сообщение: BUG #4119: Add foreign key fails for non-presence of a record that does exist.
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: 'Too many LWLocks held' with GIN pg_trgm_ops index [RE-SENT]