On Mon, 2009-05-18 at 18:44 -0500, Marsh Ray wrote: > This is a connection kept open for extended periods, and used > mutithreadedly for selects only.
I have some code that will allow you to reuse snapshots from one session to another, which could help your multiple threads see a consistent view of the database. It isn't updated as yet for 8.2+. Please contact me off-list if you're interested. I hope it will be part of PostgreSQL one day. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
