Logical decoding fast-forward and slot advance
| От | Petr Jelinek |
|---|---|
| Тема | Logical decoding fast-forward and slot advance |
| Дата | |
| Msg-id | 5c26ff40-8452-fb13-1bea-56a0338a809a@2ndquadrant.com обсуждение исходный текст |
| Ответы |
Re: Logical decoding fast-forward and slot advance
Re: Logical decoding fast-forward and slot advance |
| Список | pgsql-hackers |
Hi, Attached is patch which adds ability to do fast-forwarding while decoding. That means wal is consumed as fast as possible and changes are not given to output plugin for sending. The implementation is less invasive than I originally though it would be. Most of it is just additional filter condition in places where we would normally filter out changes because we don't yet have full snapshot. This is useful for multiple things. It enables us to do the replication slot advance for both physical and logical slots, something that Magnus took stab at some time ago, but does not seem like it went anywhere (this is useful for replication tooling). This patch adds SQL visible pg_replication_slot_advance() function for that use case. It also makes second phase (after we reached SNAPBUILD_FULL_SNAPSHOT) of replication slot creation faster, especially when there are big transactions as the reorder buffer does not have to deal with data changes and does not have to spill to disk. And finally it will be useful for developing failover support of slots. -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Вложения
В списке pgsql-hackers по дате отправления: