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

From Любен Каравелов
Subject Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility
Date
Msg-id e673b0d46aca6654c741d0bf7a82fa22.mailbg@beta.mail.bg
Whole thread Raw
In response to Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers

----- Цитат от Hannu Krosing (hannu@krosing.net), на 19.10.2012 в 14:17 -----

On 10/19/2012 04:26 AM, Ants Aasma wrote:
On Thu, Oct 18, 2012 at 10:03 PM, Hannu Krosing <hannu@2ndquadrant.com> wrote:
Hmm. Maybe we should think of implementing this as REMOTE TABLE, that
is a table which gets no real data stored locally but all insert got through
WAL
and are replayed as real inserts on slave side.
FWIW, MySQL calls this exact concept the "black hole" storage engine.
In this case calling this WRITE ONLY TABLE does not seem so strange
anymore :)

Or even PERSISTENT WRITE ONLY TABLE to make the paradox more explicit.

Oracle call this "Streams" and they build application queues ("Advanced queuing") and replication solution ("Advanced replication") on them.

Why not call the feature "STREAM TABLE"?

Best regards

--
Luben Karavelov

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: September 2012 commitfest
Next
From: Fujii Masao
Date:
Subject: Re: [BUG] False indication in pg_stat_replication.sync_state