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
<div id="yass_top_edge_dummy" style="width: 1px; height: 1px; padding: 0px; margin: -17px 0px 0px; border-width: 0px;
display:block;"></div><div id="yass_top_edge" style="background-image: url("chrome://yass/content/edgebgtop.png");
background-attachment:scroll; background-position: center bottom; padding: 0px; margin: 0px 0px 16px -12px;
border-width:0px; height: 0px; display: block; width: 990px;"></div><p style="font-family: Tahoma,sans-serif;
font-size:13px; margin-top: 16px;"><span style="color:#999999;">----- Цитат от Hannu Krosing (hannu@krosing.net), на
19.10.2012в 14:17 -----</span><blockquote style="border:none; padding:0; margin:0; background-color:#1010ff;"
type="cite"><divstyle="margin-left:2px; background-color:white;"><div style="margin-left:13px;"> On 10/19/2012 04:26
AM,Ants Aasma wrote:<br /><blockquote style="border:none; padding:0; margin:0; background-color:#1010ff;"
type="cite"><divstyle="margin-left:2px; background-color:white;"><div style="margin-left:13px;">On Thu, Oct 18, 2012 at
10:03PM, Hannu Krosing <hannu@2ndquadrant.com> wrote:<br /><blockquote style="border:none; padding:0; margin:0;
background-color:#1010ff;"type="cite"><div style="margin-left:2px; background-color:white;"><div
style="margin-left:13px;">Hmm.Maybe we should think of implementing this as REMOTE TABLE, that<br />is a table which
getsno real data stored locally but all insert got through<br />WAL<br />and are replayed as real inserts on slave
side.<br/></div></div></blockquote>FWIW, MySQL calls this exact concept the "black hole" storage engine.<br
/></div></div></blockquote>Inthis case calling this WRITE ONLY TABLE does not seem so strange <br />anymore :)<br /><br
/>Oreven PERSISTENT WRITE ONLY TABLE to make the paradox more explicit.<br /><br /></div></div></blockquote><p
style="font-family:Tahoma,sans-serif; font-size:13px;"><p style="line-height: 16px; font-size: 13px; font-family:
Tahoma,sans-serif;margin: 16px 0px;" valid="true">Oracle call this "Streams" and they build application queues
("Advancedqueuing") and replication solution ("Advanced replication") on them.<br /><p style="line-height: 16px;
font-size:13px; font-family: Tahoma,sans-serif; margin: 16px 0px;" valid="true">Why not call the feature "STREAM
TABLE"?<pstyle="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin: 16px 0px;"
valid="true">Bestregards<br /><p style="line-height: 16px; font-size: 13px; font-family: Tahoma,sans-serif; margin:
16px0px;" valid="true">--<br />Luben Karavelov<div id="yass_bottom_edge" style="background-image:
url("chrome://yass/content/edgebgbot.png");background-position: 0px 0px; position: absolute; margin: 0px; padding: 0px;
border-width:0px; height: 0px; left: 0px; top: 384px; width: 100%; display: block;"></div> 

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