thx, the fact that the query runs under pentaho at least half of the time (used to be most of the time) makes me think it will run on the db. I'll try to get a handle on the cpu/handle info u requested. -- View this message in context: http://postgresql.nabble.com/postgres-sometimes-returns-no-data-tp5873720p5873731.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general