I haven't had much experience (okay, I've yet to use it) with tsearch2,
but according to
http://www.postgresql.org/docs/8.0/interactive/limitations.html, GiST
does have concurrency issues "The current implementation of GiST within
PostgreSQL has some major limitations: GiST access is not concurrent"
Could this be what we are experiencing?
All GiST indexes allow only 1 writer at a time. Dunno if that's causing
your headaches. The other thing that causes deadlocks is using foreign
keys...
Chris
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings