Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwVh8-0004cB-78 for pgsql-performance@arkaria.postgresql.org; Fri, 07 Apr 2017 15:21:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cwVh7-00005b-OO for pgsql-performance@arkaria.postgresql.org; Fri, 07 Apr 2017 15:21:01 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwVfL-0004pc-KH; Fri, 07 Apr 2017 15:19:11 +0000 Received: from mxgate01.infotech-enterprises.com ([110.76.168.168] helo=mxgate01.cyient.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwVfH-0003Vy-Mz; Fri, 07 Apr 2017 15:19:10 +0000 X-IronPort-AV: E=Sophos;i="5.37,165,1488825000"; d="scan'208";a="67943111" Received: from unknown (HELO CYMADFPBSMTP) ([172.17.1.108]) by mxgate01.cyient.com with ESMTP; 07 Apr 2017 20:32:00 +0530 Received: from CYMADFPBSMTP.CORP.CYIENT.COM (CYMADFPBSMTP.CORP.CYIENT.COM [127.0.0.1]) by CYMADFPBSMTP.CORP.CYIENT.COM (Service) with ESMTP id 9C18381C22B7; Fri, 7 Apr 2017 20:45:35 +0530 (IST) Received: from CYINMBX1.CORP.CYIENT.COM (unknown [172.17.4.161]) by CYMADFPBSMTP.CORP.CYIENT.COM (Service) with ESMTP id 83A4681C22AA; Fri, 7 Apr 2017 20:45:35 +0530 (IST) Received: from CYINMBX4.CORP.CYIENT.COM (172.17.4.164) by CYINMBX1.CORP.CYIENT.COM (172.17.4.161) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.544.27; Fri, 7 Apr 2017 20:48:58 +0530 Received: from CYINMBX4.CORP.CYIENT.COM ([fe80::e40c:d4fe:9e0c:f465]) by CYINMBX4.CORP.CYIENT.COM ([fe80::e40c:d4fe:9e0c:f465%19]) with mapi id 15.01.0544.027; Fri, 7 Apr 2017 20:48:58 +0530 From: Dinesh Chandra 12108 To: vinny CC: "pgsql-performance-owner@postgresql.org" , "pgsql-performance@postgresql.org" Subject: Re: Filter certain range of IP address. Thread-Topic: [PERFORM] Filter certain range of IP address. Thread-Index: AdKvqS8tSZa+6/OOQPSDNHJv3aWgD///pikA//+VovA= Date: Fri, 7 Apr 2017 15:18:58 +0000 Message-ID: <705a033c9efe4a75830cc76b154e18a0@cyient.com> References: <9deae42ab489b5856f600ea514bcd51a@xs4all.nl> In-Reply-To: <9deae42ab489b5856f600ea514bcd51a@xs4all.nl> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [172.17.4.81] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-Pg-Spam-Score: -3.5 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org RGVhciBWaW5ueSwNCg0KVGhhbmtzIGZvciB5b3VyIHZhbHVhYmxlIHJlcGxh eS4NCg0KYnV0IEkgbmVlZCBhIHNlbGVjdCBxdWVyeSwgd2hpY2ggc2VsZWN0 IG9ubHkgdGhhdCByZWNvcmQgd2hpY2ggc3RhcnRzIGZyb20gSVAgIjE3Mi4y My4xMTAiIG9ubHkgZnJvbSBiZWxvdyB0YWJsZS4NCg0KeHh4CTE3Mi4yMy4x MTAuMTc1DQp5eXkJMTcyLjIzLjExMC4xNzgNCnp6egkxNzIuMjMuMTEwLjE3 Nw0KYWFhCTE3Mi4yMy4xMTAuMTc2DQpiYmIJMTcyLjIzLjExMS4xODANCmNj YwkxNzIuMjMuMTE1LjI2DQoNClJlZ2FyZHMsDQpEaW5lc2ggQ2hhbmRyYQ0K fERhdGFiYXNlIGFkbWluaXN0cmF0b3IgKE9yYWNsZS9Qb3N0Z3JlU1FMKXwg Q3lpZW50IEx0ZC4gTm9pZGEuDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCk1v YmlsZTogKzkxLTk5NTM5NzU4NDkgfCBFeHQgMTA3OCB8ZGluZXNoLmNoYW5k cmFAY3lpZW50LmNvbSANClBsb3QgTm8uIDcsIE5TRVosIFBoYXNlLUlJICxO b2lkYS1EYWRyaSBSb2FkLCBOb2lkYSAtIDIwMSAzMDUsSW5kaWEuDQoNCi0t LS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpGcm9tOiB2aW5ueSBbbWFpbHRv OnZpbm55QHhzNGFsbC5ubF0gDQpTZW50OiAwNyBBcHJpbCwgMjAxNyA3OjUy IFBNDQpUbzogRGluZXNoIENoYW5kcmEgMTIxMDggPERpbmVzaC5DaGFuZHJh QGN5aWVudC5jb20+DQpDYzogcGdzcWwtcGVyZm9ybWFuY2Utb3duZXJAcG9z dGdyZXNxbC5vcmc7IHBnc3FsLXBlcmZvcm1hbmNlQHBvc3RncmVzcWwub3Jn DQpTdWJqZWN0OiBSZTogW1BFUkZPUk1dIEZpbHRlciBjZXJ0YWluIHJhbmdl IG9mIElQIGFkZHJlc3MuDQoNCk9uIDIwMTctMDQtMDcgMTY6MTMsIERpbmVz aCBDaGFuZHJhIDEyMTA4IHdyb3RlOg0KPiBIaSBleHBlcnQsDQo+IA0KPiBN YXkgSSBrbm93IGhvdyB0byBzZWxlY3QgYSByYW5nZSBvZiBJUCBhZGRyZXNz Lg0KPiANCj4gRXhhbXBsZTogSSBoYXZlIG51bWJlciBvZiBkaWZmZXJlbnQt MiBJUCdzIHByZXNlbnQgaW4gYSB0YWJsZS4NCj4gDQo+IEkgSEFWRSBUTyBT RUxFQ1QgT05MWSBUSEFUIElQIEFERFJFU1MgV0hJQ0ggRE9FUyBOT1QgU1RB UlQgRlJPTSBQUkVGSVggDQo+IOKAnDE3Mi4yMy4xMTDigJ0uDQo+IA0KPiBU aGFua3MgaW4gYWR2YW5jZQ0KPiANCj4gUkVHQVJEUywNCj4gDQo+IERJTkVT SCBDSEFORFJBDQo+IA0KPiB8REFUQUJBU0UgQURNSU5JU1RSQVRPUiAoT1JB Q0xFL1BPU1RHUkVTUUwpfCBDWUlFTlQgTFRELiBOT0lEQS4NCj4gDQo+IC0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLQ0KPiANCj4gTW9iaWxlOiArOTEtOTk1Mzk3 NTg0OSB8IEV4dCAxMDc4IHxkaW5lc2guY2hhbmRyYUBjeWllbnQuY29tDQo+ IA0KPiBQbG90IE5vLiA3LCBOU0VaLCBQaGFzZS1JSSAsTm9pZGEtRGFkcmkg Um9hZCwgTm9pZGEgLSAyMDEgMzA1LEluZGlhLg0KDQoNCklmIHlvdSBzdG9y ZSB0aGUgaXAgYWRkcmVzcyBhcyB0aGUgSU5FVCBkYXRhdHlwZSB0aGVuIHlv dSBjYW4gdXNlIHRoZSBJTkVUIG9wZXJhdG9ycyB0byBzZWUgaWYgYW55IGFy Yml0cmF0eSBudW1iZXIgb2YgYml0cyBtYXRjaCwgdGhlIGZpcnN0IDMgYnl0 ZXMgbWVhbnMgdGhlIGZpcnN0IDI0IGJpdHM6DQoNCg0KU0VMRUNUICcxNzIu MjMuMTEwLjU1Jzo6aW5ldCA8PCAnMTcyLjIzLjExMC4xLzI0Jzo6aW5ldDsN CiAgP2NvbHVtbj8NCi0tLS0tLS0tLS0NCiAgdA0KKDEgcm93KQ0KDQoNClNF TEVDVCAnMjcyLjIzLjExMC41NSc6OmluZXQgPDwgJzE3Mi4yMy4xMTAuMS8y NCc6OmluZXQ7DQogID9jb2x1bW4/DQotLS0tLS0tLS0tDQogIGYNCigxIHJv dykNCg0KU2VlIGFsc286IGh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2Rv Y3MvOS4zL3N0YXRpYy9mdW5jdGlvbnMtbmV0Lmh0bWwNCgotLSAKU2VudCB2 aWEgcGdzcWwtcGVyZm9ybWFuY2UgbWFpbGluZyBsaXN0IChwZ3NxbC1wZXJm b3JtYW5jZUBwb3N0Z3Jlc3FsLm9yZykKVG8gbWFrZSBjaGFuZ2VzIHRvIHlv dXIgc3Vic2NyaXB0aW9uOgpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21h aWxwcmVmL3Bnc3FsLXBlcmZvcm1hbmNlCg==