暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

PostgreSQL 14 扩展逻辑decoding API 应对长事务逻辑复制优化 - Extend the logical decoding output plugin API with stream methods.

digoal 2020-08-03
229

作者

digoal

日期

2020-08-03

标签

PostgreSQL , Extend the logical decoding output plugin API with stream methods


背景

增加逻辑decoding OPENAPI, 在处理长事务时更加适合.

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=45fdc9738b36d1068d3ad8fdb06436d6fd14436b

```
Extend the logical decoding output plugin API with stream methods.
author Amit Kapila akapila@postgresql.org
Tue, 28 Jul 2020 10:36:44 +0800 (08:06 +0530)
committer Amit Kapila akapila@postgresql.org
Tue, 28 Jul 2020 10:39:44 +0800 (08:09 +0530)
commit 45fdc9738b36d1068d3ad8fdb06436d6fd14436b
tree 1168c9368d1d3c0e7daa47f82c5f8531ed0197c5 tree | snapshot
parent 13838740f61fc455aa4196d257efc0b761daba1f commit | diff
Extend the logical decoding output plugin API with stream methods.

This adds seven methods to the output plugin API, adding support for
streaming changes of large in-progress transactions.

  • stream_start
  • stream_stop
  • stream_abort
  • stream_commit
  • stream_change
  • stream_message
  • stream_truncate

Most of this is a simple extension of the existing methods, with
the semantic difference that the transaction (or subtransaction)
is incomplete and may be aborted later (which is something the
regular API does not really need to deal with).

This also extends the 'test_decoding' plugin, implementing these
new stream methods.

The stream_start/start_stop are used to demarcate a chunk of changes
streamed for a particular toplevel transaction.

This commit simply adds these new APIs and the upcoming patch to "allow
the streaming mode in ReorderBuffer" will use these APIs.
```

PostgreSQL 许愿链接

您的愿望将传达给PG kernel hacker、数据库厂商等, 帮助提高数据库产品质量和功能, 说不定下一个PG版本就有您提出的功能点. 针对非常好的提议,奖励限量版PG文化衫、纪念品、贴纸、PG热门书籍等,奖品丰富,快来许愿。开不开森.

9.9元购买3个月阿里云RDS PostgreSQL实例

PostgreSQL 解决方案集合

德哥 / digoal's github - 公益是一辈子的事.

digoal's wechat

文章转载自digoal,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论