Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42441=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Wes6q-0008Eh-SV
 for pgsql-admin@arkaria.postgresql.org; Mon, 28 Apr 2014 20:25:05 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42441=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Wes6q-0005L3-9G
 for pgsql-admin@arkaria.postgresql.org; Mon, 28 Apr 2014 20:25:04 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tgl@sss.pgh.pa.us>) id 1Wes6p-0005Kv-5t
 for pgsql-admin@postgresql.org; Mon, 28 Apr 2014 20:25:03 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <tgl@sss.pgh.pa.us>) id 1Wes6m-0002r3-HU
 for pgsql-admin@postgresql.org; Mon, 28 Apr 2014 20:25:02 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
 by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id s3SKP0h2026636;
 Mon, 28 Apr 2014 16:25:00 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ray Stell <stellr@vt.edu>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: 9.0.15 WAL mis-replay status?
In-reply-to: <5484E2AE-F298-470B-9412-05D9EEFEAE7F@vt.edu>
References: <8D8B1117-25D3-4C82-9FB5-6CE5C8E2C3EC@vt.edu>
 <12664.1398697642@sss.pgh.pa.us>
 <5484E2AE-F298-470B-9412-05D9EEFEAE7F@vt.edu>
Comments: In-reply-to Ray Stell <stellr@vt.edu>
 message dated "Mon, 28 Apr 2014 15:41:23 -0400"
Date: Mon, 28 Apr 2014 16:25:00 -0400
Message-ID: <26635.1398716700@sss.pgh.pa.us>
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Ray Stell <stellr@vt.edu> writes:
> On Apr 28, 2014, at 11:07 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Note however that the issue could only arise on tables that exceed 1GB

> I assume this is true also for other relkinds?  I have >1G indexes here, but tables are <1G.  TIA.

Right, such indexes would be at risk.  However, if it's only the indexes
that exceed 1G, you could consider reindexing those indexes as an
alternative to a full resync.

			regards, tom lane


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