[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