tag:blogger.com,1999:blog-20038672.post3510774910547700592..comments2024-03-28T00:58:29.187-04:00Comments on Robert Haas: More Musings on Logical ReplicationRobert Haashttp://www.blogger.com/profile/08393677427643988650noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-20038672.post-78113400793157159592011-03-07T07:19:35.904-05:002011-03-07T07:19:35.904-05:00Oracle introduced the concept of supplemental logg...Oracle introduced the concept of supplemental logging to support logical standbys and other logical replication solutions.<br /><br />There is a performance penalty involved, but no clear documentation as to what this is. In my experience, DBAs are very reluctant to enable this as they don't know what performance impact it will have on their production systems.<br /><br />So one thing we need to do well is to document exactly what performance impact any additional logging (and indeed any form of replication, even physical hot standby as it exists today) will have on the source database.Colin 't Harthttps://www.blogger.com/profile/15623835285718803326noreply@blogger.comtag:blogger.com,1999:blog-20038672.post-60616524424165545612011-03-03T13:53:19.904-05:002011-03-03T13:53:19.904-05:00Second, unless we want to be able to replicate onl...<b>Second, unless we want to be able to replicate only to a cluster that is guaranteed to be exactly binary-compatible</b><br /><br />At times, it would have been useful to be able to perform a basic backup and restore to a machine that isn't binary compatible.<br /><br />HOT Standby has the same type of issue.<br /><br />If this can be solved on the slave in some more generic way, even with a 25% performance penalty, it could be very useful on its own.Rod Taylornoreply@blogger.com