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
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
w to keep progres process running when I logout?
2. How to startup postgres with NT startup?
Regards,
wit
