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

----- Цитат от Hannu Krosing (hannu(at)krosing(dot)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 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