Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility

From: Greg Stark <stark(at)mit(dot)edu>
To: Hannu Krosing <hannu(at)2ndquadrant(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility
Date: 2012-10-17 17:17:29
Message-ID: CAM-w4HOcgdYQxs2Ce0psGCf3QDP2HvioOD4XPQwh+BLNch9T_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 17, 2012 at 11:26 AM, Hannu Krosing <hannu(at)2ndquadrant(dot)com> wrote:
> The simplest usage would be implementing "remote log tables" that is
> tables, where you do INSERT on the master side, but it "inserts" only
> a logical WAL record and nothing else.
>
> On subscriber side your replay process reads this WAL record as an
> "insert event" and if the table is declared as an ordinary table on
> subscriber, it performs an insert there.

What kinds of applications would need that?

--
greg

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Abhijit Menon-Sen 2012-10-17 17:19:47 Re: Doc patch "only relevant" -> "relevant only"
Previous Message Merlin Moncure 2012-10-17 17:13:47 Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows