Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility
Date
Msg-id 17539.1351001630@sss.pgh.pa.us
Whole thread Raw
In response to Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility  (Hannu Krosing <hannu@2ndQuadrant.com>)
Responses Re: [RFC] CREATE QUEUE (log-only table) for londiste/pgQ ccompatibility  (Hannu Krosing <hannu@krosing.net>)
List pgsql-hackers
Tree view 
[ hadn't been following this thread, sorry ]

Hannu Krosing <hannu@2ndQuadrant.com> writes:
> My RFC was for a proposal to skip writing the unneeded info in local
> tables and put it _only_ in WAL.

This concept seems fundamentally broken.  What will happen if the master
crashes immediately after emitting the WAL record?  It will replay it
locally, that's what, and thus you have uncertainty about whether the
master will contain the data or not.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Visual Studio 2012 RC
Next
From: Alvaro Herrera
Date:
Subject: Re: Incorrect behaviour when using a GiST index on points