On 11/23/2015 2:41 AM, Chris Withers wrote:
If it's totally wrong, how should I be looking to approach the problem?
depending on where these queue entries are coming from, I'd considering using a message queueing system like AMS, MQseries, etc, rather than trying to use a relational database table as a queue. your external data source(s) would write messages to this queue, and you'd have 'subscriber' processes that listen to the queue and process the messages, inserting persistent data into the database as needed.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
