Re: [GENERAL] odd locking behaviour

2013-07-21 Thread Pavel Stehule
hello It can be artefact of RI implementation. see http://michael.otacoo.com/postgresql-2/postgres-9-3-feature-highlight-for-key-share-and-for-no-key-update/ Try to 9.3, please, where RI uses more gently locks Regards Pavel Stehule Dne 21.7.2013 21:43 "Moshe Jacobson" napsal(a): > > I wish

Re: [GENERAL] odd locking behaviour

2013-07-21 Thread Moshe Jacobson
I wish one of the PG developers would respond to this... On Mon, Jul 8, 2013 at 9:54 AM, pg noob wrote: > > Thank you for the responses. Is it a bug? > I discovered this because of a db deadlock that shows up in my application > logs. > I can probably work around it to avoid the deadlock (with

[GENERAL] Index for Levenshtein distance (better format)

2013-07-21 Thread Janek Sendrowski
Hi, Im searching for a suitable Index for my query witch compares Strings with the Levenshtein distance. I read that a prefix index would fit, but I dont know how to build it. I only know that its supported by Gist. I couldn't find an instructions so I hope someone can help me.   Best regards,