Susan Cassidy wrote: > Any explanations or ideas? The processing works, because other iterations > of the program are constantly running, so the next attempt returns data, and > runs as normal. However, it bugs me that sometimes a query that should work > is returning no results, for no discernable reason.
In a producer-consumer model, at some point in time there should be between 0 and N items to consume. 0 item is no more weird than 1, or 2, or any other particular value. Personally, I would find it weird if a consumer process never had nothing to do. I would see this as a hint that the producer is over-producing. Best regards, -- Daniel PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
