Managing pgq queues
One of the core components of SkyTools is pgq. It provides a generic queuing interface, which allows you to deliver messages from a provider to an arbitrary number of consumers.
The question is: what is the point of a queue in general? A queue has some very nice features. First of all, it will guarantee the delivery of a message. In addition to that, it will make sure that the order in which the messages are put into it is preserved. This is highly important in the case of replication because we must make sure that the messages will not overtake each other.
The idea behind a queue is to be able to send anything from an entity producing the data to any other host participating in the system. This is suitable for replication and ...
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
