[ADMIN] Query with limit takes hours

On PG 9.1 and 9.2 I'm running the following query: SELECT *FROM stream_store JOIN(SELECT UNNEST(stream_store_ids) AS idFROM stream_store_version_index WHERE stream_id = 607106 AND version = 11) AS records USI

[ADMIN] Spurious failure to obtain row lock possible in PG 9.1?

I'm using Postgres 9.1 on Debian Lenny and via a Java server (JBoss AS 6.1) I'm executing a simple "select ... for update" query: SELECT importing FROM customer WHERE id = :customer_id FOR UPDATE NOWAIT Once every 10 to 20 times Postgres fails to obtain the lock for no app