| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Deadlocks in 7.4.x ... |
| Date: | 2005-05-24 01:53:39 |
| Message-ID: | 42928923.8090802@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-05-24 02:43:45 | Re: Speeding up the Postgres lexer |
| Previous Message | Christopher Kings-Lynne | 2005-05-24 01:50:07 | Re: Speeding up the Postgres lexer |