Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYsnX-0002KQ-I3 for pgsql-admin@arkaria.postgresql.org; Wed, 01 Feb 2017 11:09:59 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYsnX-0006xr-0Q for pgsql-admin@arkaria.postgresql.org; Wed, 01 Feb 2017 11:09:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYslp-0003pc-63 for pgsql-admin@postgresql.org; Wed, 01 Feb 2017 11:08:13 +0000 Received: from forward5m.cmail.yandex.net ([2a02:6b8:b030::1c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYslm-00015g-VF for pgsql-admin@postgresql.org; Wed, 01 Feb 2017 11:08:12 +0000 Received: from mxback15h.mail.yandex.net (mxback15h.mail.yandex.net [IPv6:2a02:6b8:0:f05::122]) by forward5m.cmail.yandex.net (Yandex) with ESMTP id 2ED4C21573; Wed, 1 Feb 2017 14:08:08 +0300 (MSK) Received: from web7h.yandex.ru (web7h.yandex.ru [84.201.186.36]) by mxback15h.mail.yandex.net (nwsmtp/Yandex) with ESMTP id ZsZ08sM07l-875eX6Tf; Wed, 01 Feb 2017 14:08:07 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1485947287; bh=eSyzrImtgea0oj7yLCakLpgjzwDcfSQUeyYlu0uxcGQ=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=jM4JbCTuNSXsxe8yyJXYwdwOtNvcZ42JFW0Oj0u3/8N/ubavZNNIcmnX1mIm3nL1w nmn/LkqoDaNyVxuyQo5+blbGy8+QZFJhNhOBqG9g9YMwpIDh0Sw7Lz8P32k4qlIDmS RmIEPca40FYvnctarveyXOgLX5EEY3GIjo+TA0c0= Authentication-Results: mxback15h.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web7h.yandex.ru with HTTP; Wed, 01 Feb 2017 14:08:07 +0300 From: Samed YILDIRIM To: =?utf-8?B?zprOv866zrzOrM60zrfPgiDOlM63zrzOrs+Ez4HOuc6/z4I=?= , "pgsql-admin@postgresql.org" In-Reply-To: References: Subject: Re: Big sized materialized views break replication MIME-Version: 1.0 Message-Id: <962741485947287@web7h.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 01 Feb 2017 13:08:07 +0200 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org PGRpdj5IaSBEaW1pdHJpLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkNvdWxkIHlvdSBwbGVhc2Ug c2hhcmUgUG9zdGdyZXMgaW5zdGFsbGF0aW9uIHZlcnNpb24/PC9kaXY+PGRpdj5BbHNvIHdoYXQg ZG8geW91IG1lYW4gYnkgc2F5aW5nIHJlY3JlYXRlIG1hdGVyaWFsaXplZCB2aWV3LCByZWZyZXNo IG9yIGRyb3AvY3JlYXRlPzwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PkJlc3QgcmVnYXJkcy48L2Rp dj48ZGl2PsKgPC9kaXY+PGRpdj7EsHlpIMOnYWzEscWfbWFsYXIuPC9kaXY+PGRpdj5TYW1lZCBZ SUxESVJJTTwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+ MDEuMDIuMjAxNywgMTI6NDEsICLOms6/zrrOvM6szrTOt8+CIM6UzrfOvM6uz4TPgc65zr/PgiIg Jmx0O2Rrb2ttYWRpc0BnbWFpbC5jb20mZ3Q7OjwvZGl2PjxibG9ja3F1b3RlIHR5cGU9ImNpdGUi PjxkaXY+SGVsbG8sPGRpdj7CoDwvZGl2PjxkaXY+SSB1c2UgaG90IHN0YW5kYnkgcmVwbGljYXRp b24gbW9kZS7CoDwvZGl2PjxkaXY+V2hlbiBJIHRyeSB0byByZWNyZWF0ZSBiaWcgc2l6ZWQgbWF0 ZXJpYWxpc2VkIHZpZXdzLCBhYm91dCAzRyBzaXplLCB0aGUgcmVwbGljYXRpb24gYnJlYWtzIGFu ZCBJIGhhdmUgdG8gcmVzeW5jIGl0LsKgPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SXMgdGhlcmUg YW55IHdheSB0byBhdm9pZCBpdD88L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5NeSBtYXN0ZXIgc2Vy dmVyIHNldHRpbmdzPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+PGRpdj5zaGFyZWRfYnVmZmVycyA9 IDMwR0I8L2Rpdj48ZGl2PndvcmtfbWVtID0gMzE0NmtCPC9kaXY+PGRpdj5tYWludGVuYW5jZV93 b3JrX21lbSA9IDJHQjwvZGl2PjxkaXY+ZHluYW1pY19zaGFyZWRfbWVtb3J5X3R5cGUgPSBwb3Np eDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgdGhlIGRlZmF1bHQgaXMg dGhlIGZpcnN0IG9wdGlvbjwvZGl2PjxkaXY+d2FsX2xldmVsID0gaG90X3N0YW5kYnk8L2Rpdj48 ZGl2PndhbF9idWZmZXJzID0gMTZNQjwvZGl2PjxkaXY+Y2hlY2twb2ludF9zZWdtZW50cyA9IDEy ODwvZGl2PjxkaXY+Y2hlY2twb2ludF9jb21wbGV0aW9uX3RhcmdldCA9IDAuOTwvZGl2PjxkaXY+ bWF4X3dhbF9zZW5kZXJzID0gMTI4PC9kaXY+PGRpdj53YWxfa2VlcF9zZWdtZW50cyA9IDg8L2Rp dj48ZGl2PmVmZmVjdGl2ZV9jYWNoZV9zaXplID0gOTBHQjwvZGl2PjxkaXY+ZGVmYXVsdF9zdGF0 aXN0aWNzX3RhcmdldCA9IDEwMDwvZGl2PjxkaXY+bG9nZ2luZ19jb2xsZWN0b3IgPSBvbjxzcGFu IHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgRW5hYmxlIGNhcHR1cmluZyBvZiBz dGRlcnIgYW5kIGNzdmxvZzwvZGl2PjxkaXY+bG9nX2RpcmVjdG9yeSA9ICcvdmFyL2xvZy9wb3N0 Z3Jlc3FsJzxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgZGlyZWN0b3J5 IHdoZXJlIGxvZyBmaWxlcyBhcmUgd3JpdHRlbiw8L2Rpdj48ZGl2PmxvZ19maWxlbmFtZSA9ICdw b3N0Z3Jlc3FsLSVZLSVtLSVkLmxvZyc8c3BhbiBzdHlsZT0id2hpdGUtc3BhY2U6cHJlOyI+IDwv c3Bhbj4jIGxvZyBmaWxlIG5hbWUgcGF0dGVybiw8L2Rpdj48ZGl2PmxvZ19yb3RhdGlvbl9hZ2Ug PSAxZDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgQXV0b21hdGljIHJv dGF0aW9uIG9mIGxvZ2ZpbGVzIHdpbGw8L2Rpdj48ZGl2PmxvZ19taW5fZHVyYXRpb25fc3RhdGVt ZW50ID0gMzAwMDxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgLTEgaXMg ZGlzYWJsZWQsIDAgbG9ncyBhbGwgc3RhdGVtZW50czwvZGl2PjxkaXY+bG9nX2xpbmVfcHJlZml4 ID0gJyV0IMKgJzxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgc3BlY2lh bCB2YWx1ZXM6PC9kaXY+PGRpdj5sb2dfdGltZXpvbmUgPSAnbG9jYWx0aW1lJzwvZGl2PjxkaXY+ c3RhdHNfdGVtcF9kaXJlY3RvcnkgPSAnL3Zhci9ydW4vcG9zdGdyZXNxbC85LjQtbWFpbi5wZ19z dGF0X3RtcCc8L2Rpdj48ZGl2PmF1dG92YWN1dW0gPSBvbjxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFj ZTpwcmU7Ij4gPC9zcGFuPiMgRW5hYmxlIGF1dG92YWN1dW0gc3VicHJvY2Vzcz8gwqAnb24nPC9k aXY+PGRpdj5sb2dfYXV0b3ZhY3V1bV9taW5fZHVyYXRpb24gPSAtMTxzcGFuIHN0eWxlPSJ3aGl0 ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgLTEgZGlzYWJsZXMsIDAgbG9ncyBhbGwgYWN0aW9ucyBh bmQ8L2Rpdj48ZGl2PmF1dG92YWN1dW1fbWF4X3dvcmtlcnMgPSAzPHNwYW4gc3R5bGU9IndoaXRl LXNwYWNlOnByZTsiPiA8L3NwYW4+IyBtYXggbnVtYmVyIG9mIGF1dG92YWN1dW0gc3VicHJvY2Vz c2VzPC9kaXY+PGRpdj5hdXRvdmFjdXVtX25hcHRpbWUgPSAxNW1pbjxzcGFuIHN0eWxlPSJ3aGl0 ZS1zcGFjZTpwcmU7Ij4gPC9zcGFuPiMgdGltZSBiZXR3ZWVuIGF1dG92YWN1dW0gcnVuczwvZGl2 PjxkaXY+YXV0b3ZhY3V1bV92YWN1dW1fdGhyZXNob2xkID0gNTA8c3BhbiBzdHlsZT0id2hpdGUt c3BhY2U6cHJlOyI+IDwvc3Bhbj4jIG1pbiBudW1iZXIgb2Ygcm93IHVwZGF0ZXMgYmVmb3JlPC9k aXY+PGRpdj5hdXRvdmFjdXVtX2FuYWx5emVfdGhyZXNob2xkID0gNTA8c3BhbiBzdHlsZT0id2hp dGUtc3BhY2U6cHJlOyI+IDwvc3Bhbj4jIG1pbiBudW1iZXIgb2Ygcm93IHVwZGF0ZXMgYmVmb3Jl PC9kaXY+PGRpdj7CoDwvZGl2PjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlJlZ2FyZHMsPC9kaXY+ PGRpdj5EaW1pdHJpczwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT4=