Re: postgres 7.2 features. - Mailing list pgsql-hackers

From Philip Warner
Subject Re: postgres 7.2 features.
Date
Msg-id 3.0.5.32.20000711163713.023ba8e0@mail.rhyme.com.au
Whole thread Raw
In response to Re: postgres 7.2 features.  (Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>)
List pgsql-hackers
At 11:27 11/07/00 +1000, Chris Bitmead wrote:
>
>> It was mentioned here that triggers could be used for async replication,
>> as well as WAL.
>
>Same story. Major inefficency. Replication is tough enough without
>mucking
>around with triggers. Once the trigger executes you've got to go and
>store
>the data in the database again anyway. Then figure out when to delete
>it.
>

The WAL *should* be the most efficient technique for replication (this said
without actually having seen it ;-}). 



----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.C.N. 008 659 498)             |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/


pgsql-hackers by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: Alternative new libpq interface.
Next
From: Philip Warner
Date:
Subject: Patch for pg_dump