Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M239006=pgsql-hackers-arkari@postgresql.org>)
 id 1VoD1m-0004S6-PI
 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 14:02:11 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M239006=pgsql-hackers-arkari@postgresql.org>)
 id 1VoD1m-0008TW-8K
 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 14:02:10 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <andres@2ndquadrant.com>) id 1VoD1k-0008RR-18
 for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 14:02:08 +0000
Received: from moutng.kundenserver.de ([212.227.17.8])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <andres@2ndquadrant.com>) id 1VoD1d-0007IQ-G2
 for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 14:02:07 +0000
Received: from anarazel.de (p5DDC5FC6.dip0.t-ipconnect.de [93.220.95.198])
 by mrelayeu.kundenserver.de (node=mrbap2) with ESMTP (Nemesis)
 id 0LejD4-1VFeYo2PMM-00qg4C; Wed, 04 Dec 2013 15:02:00 +0100
Received: by anarazel.de (Postfix, from userid 1000)
 id C5F8F1019EF; Wed,  4 Dec 2013 15:01:59 +0100 (CET)
Date: Wed, 4 Dec 2013 15:01:59 +0100
From: Andres Freund <andres@2ndquadrant.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: =?iso-8859-1?Q?Fabr=EDzio?= Mello <fabriziomello@gmail.com>,
 Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Time-Delayed Standbys
Message-ID: <20131204140159.GL24801@awork2.anarazel.de>
References: 
 <CAFcNs+oXq5ZPaKARRn3VZGzX+AnTZCaEjR6VmQT_tvoFiqgaSg@mail.gmail.com>
 <CA+U5nML64Y7Nf0mpQirk-tOWrV+ZQ3y8DdRgk2mP+e3kGT16Mw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+U5nML64Y7Nf0mpQirk-tOWrV+ZQ3y8DdRgk2mP+e3kGT16Mw@mail.gmail.com>
X-Provags-ID: V02:K0:Q6Qb4PJQwDrxmE1rnPXKVmOGe4uBNA5Znpe50sOjv4v
 woN8spfvMpkKcgesjMYInHI1dY8z60u9Z1YSS8p1ahpdmqKlVe
 Pm3nIwMHnFjnedLPb2613xlvOYpIq6wQ4+gy83y8me/bvu0Vn+
 VTPzwxnvCV6YiiUaTYGSrDCCY2AKdp4B5Gh+o08e+K1qVC7MXM
 b2NV5WWwTkZgtCATuSNe7oehvRwFPSJyOY2gs0vw6mnfcakY+C
 vRtnHFNKrzaQfJCMP7HtAIsswjjyrQQfHB2WBEcXmtWptbrMc3
 4YBC4c6vZBftwJyWfSmnomiyGmzB/HQxh5NvW2PKG7nrRFBiez
 hgZt7MArsKtTaG6ro3nyBZK9bLPx6yKAyfeSoZ6lo
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Hi,

On 2013-12-03 19:33:16 +0000, Simon Riggs wrote:
> > - compute recoveryUntilDelayTime in XLOG_XACT_COMMIT and
> > XLOG_XACT_COMMIT_COMPACT checks
> 
> Why just those? Why not aborts and restore points also?

What would the advantage of waiting on anything but commits be? If it's
not a commit, the action won't change the state of the database (yesyes,
there are exceptions, but those don't have a timestamp)...

Greetings,

Andres Freund

-- 
 Andres Freund	                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers