Bug 339 - Using binary copy format for sl_log data transfer
Summary: Using binary copy format for sl_log data transfer
Status: NEW
Alias: None
Product: Slony-I
Classification: Unclassified
Component: slon (show other bugs)
Version: devel
Hardware: All All
: low enhancement
Assignee: Slony Bugs List
URL:
Depends on:
Blocks:
 
Reported: 2014-04-11 07:54 UTC by Jan Wieck
Modified: 2014-04-11 07:54 UTC (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Wieck 2014-04-11 07:54:26 UTC 
It was suggested by Peter Goeghegan that Slony could eventually use a binary copy to transport the sl_log data. 

The binary copy protocol is using network byte order and since the schema of the sl_log_1/sl_log_2 tables within one cluster will always be identical, even across different PostgreSQL versions and architectures, this should actually create no problems.

I have no idea how much (or little) of a performance improvement that may result in. But it is worth investigating.