Re: HOOKS for Synchronous Replication? - Mailing list pgsql-hackers

From Dann Corbit
Subject Re: HOOKS for Synchronous Replication?
Date
Msg-id D425483C2C5C9F49B5B7A41F8944154757D34C@postal.corporate.connx.com
Whole thread Raw
In response to HOOKS for Synchronous Replication?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers

A general purpose log miner is also useful in many other areas besides replication.

 


From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Jonah H. Harris
Sent: Thursday, December 08, 2005 11:32 AM
To: Jim C. Nasby
Cc: Darcy Buskermolen; pgsql-hackers@postgresql.org; Tom Lane; Christopher Kings-Lynne
Subject: Re: [HACKERS] HOOKS for Synchronous Replication?

 

On 12/8/05, Jim C. Nasby <jim@nasby.net> wrote:

While this code might be useful, whouldn't it be much more valuable to
provide hooks into xlog so that we could do non-trigger-based
replication? (As well as non-trigger-based materialized views...)


If we're going to do hooks for replication, I think we should look at including xlog.  Trigger-based replication is an OLTP performance killer if you're just looking to do async replication.

pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: HOOKS for Synchronous Replication?
Next
From: Jan Wieck
Date:
Subject: Re: HOOKS for Synchronous Replication?