Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRJYS-0002xo-Cm for pgsql-bugs@arkaria.postgresql.org; Thu, 25 Aug 2022 20:34:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oRJYR-0006Av-8F for pgsql-bugs@arkaria.postgresql.org; Thu, 25 Aug 2022 20:34:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRJKi-0001la-SC for pgsql-bugs@lists.postgresql.org; Thu, 25 Aug 2022 20:20:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRJKf-0006oF-QJ for pgsql-bugs@lists.postgresql.org; Thu, 25 Aug 2022 20:20:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=aqHOClWMLreiWVwCzb1TBqBJvk23HTdFaw81V0KM8z4=; b=ykjpkYJLY+XfnW03ihJL7ozPb1 7ryOfnfgbq497lfijP9kR2WmO4pDCVcZqmIVCwMWPoL6Z3dtcj9bQKcpO2vzgrDH1W7z7BbYLYhpN A0tJErdbwMf7NpbEXUEzou+jvtLaYOEQ0IUVXQ7FchDryFBNvawVGGxCcfApTInFOSrIPd01kTXr2 0ItSMyt2QGjJjU3CGMNqD+NczdLCPEGDLBBfLcUFlyH8WoD/9fpdueYO29cFX5QwCA/VGFSm0pQMf jtQbstzYgcNwi5KhMUJ+Mhif027/CkoepRgS++e1nUKHmFNvwcTANiEaXm0vBpMZqADFPQPOcf+i2 QAqrFUog==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oRJKe-0000xD-Lt for pgsql-bugs@lists.postgresql.org; Thu, 25 Aug 2022 20:20:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oRJKc-004mWb-Ny for pgsql-bugs@lists.postgresql.org; Thu, 25 Aug 2022 20:20:02 +0000 Content-Type: multipart/mixed; boundary="===============5350941378145853741==" MIME-Version: 1.0 Subject: BUG #17594: conditional hash indexes size (hash index ignore WHERE condition during CREATE INDEX?) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 25 Aug 2022 20:19:54 +0000 Message-ID: <17594-fca95086967695be@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5350941378145853741== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU5NApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuNApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwN Cg0KSSBmb3VuZCB2ZXJ5IHdlaXJkIHNpdHVhdGlvbiB3aXRoIHNpemUgb2YgaGlnaGx5IHNlbGVj dGl2ZSBwYXJ0aWFsIGhhc2gKaW5kZXhlcyAodGhleSBoYXMgYWxtb3N0IHNhbWUgc2l6ZSBhcyBm dWxsIHRhYmxlIGhhc2ggaW5kZXgpLg0KVGVzdCBjYXNlOg0KDQpjcmVhdGUgdGFibGUgdGVzdF8x MDAwMDAwIGFzIHNlbGVjdCBpZCBmcm9tIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwMDAwKSBhcwpn KGlkKTsNCmNyZWF0ZSBpbmRleCB0ZXN0XzEwMDAwMDBfaGFzaF9mdWxsX2lkeCBvbiB0ZXN0XzEw MDAwMDAgdXNpbmcgaGFzaChpZCk7DQpjcmVhdGUgaW5kZXggdGVzdF8xMDAwMDAwX2hhc2hfcGFy dGlhbF9pZHggb24gdGVzdF8xMDAwMDAwIHVzaW5nIGhhc2goaWQpCndoZXJlIGlkPDExOw0KY3Jl YXRlIHRhYmxlIHRlc3RfMTAgYXMgc2VsZWN0IGlkIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsIDEw KSBhcyBnKGlkKTsNCmNyZWF0ZSBpbmRleCB0ZXN0XzEwX2hhc2hfZnVsbCAgb24gdGVzdF8xMCAg dXNpbmcgaGFzaChpZCk7DQoNClxkaSsgdGVzdF8xKg0KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBMaXN0IG9mIHJlbGF0aW9ucw0KIFNjaGVtYSB8 ICAgICAgICAgICAgIE5hbWUgICAgICAgICAgICAgIHwgVHlwZSAgfCBPd25lciAgfCAgICBUYWJs ZSAgICAgfApQZXJzaXN0ZW5jZSB8IEFjY2VzcyBtZXRob2QgfCBTaXplICB8IERlc2NyaXB0aW9u IA0KLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tKy0tLS0t LS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0r LS0tLS0tLS0tLS0tLQ0KIHB1YmxpYyB8IHRlc3RfMTAwMDAwMF9oYXNoX2Z1bGxfaWR4ICAgIHwg aW5kZXggfCBtYm9ndWsgfCB0ZXN0XzEwMDAwMDAgfApwZXJtYW5lbnQgICB8IGhhc2ggICAgICAg ICAgfCAzMiBNQiB8IA0KIHB1YmxpYyB8IHRlc3RfMTAwMDAwMF9oYXNoX3BhcnRpYWxfaWR4IHwg aW5kZXggfCBtYm9ndWsgfCB0ZXN0XzEwMDAwMDAgfApwZXJtYW5lbnQgICB8IGhhc2ggICAgICAg ICAgfCAyOCBNQiB8IA0KIHB1YmxpYyB8IHRlc3RfMTBfaGFzaF9mdWxsICAgICAgICAgICAgIHwg aW5kZXggfCBtYm9ndWsgfCB0ZXN0XzEwICAgICAgfApwZXJtYW5lbnQgICB8IGhhc2ggICAgICAg ICAgfCA4MCBrQiB8IA0KDQpFeHBlY3RlZDogdGhlIHRlc3RfMTAwMDAwMF9oYXNoX3BhcnRpYWxf aWR4ICBhbmQgdGVzdF8xMF9oYXNoX2Z1bGwgaW5kZXhlcwpzaG91bGQgaGF2ZSBzYW1lIG9yIGF0 IGxlYXN0IGNsb3NlIHNpemUgYmVjYXVzZSB0aGV5IGluZGV4IHNhbWUgYW1vdW50IG9mCnJvd3Mg KDEwKToNCg0Kc2VsZWN0IGNvdW50KCopIGZyb20gdGVzdF8xMDsNCiBjb3VudCANCi0tLS0tLS0N CiAgICAxMA0KDQpzZWxlY3QgY291bnQoKikgZnJvbSB0ZXN0XzEwMDAwMDAgd2hlcmUgaWQ8MTE7 DQogY291bnQgDQotLS0tLS0tDQogICAgMTAKCg== --===============5350941378145853741==--