Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bemWC-0001ct-6u for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2016 17:08:12 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bemWB-0000G8-PW for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Aug 2016 17:08:11 +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 1bemUm-0007Ax-Mz for pgsql-hackers@postgresql.org; Tue, 30 Aug 2016 17:06:44 +0000 Received: from smtprelay0199.b.hostedemail.com ([64.98.42.199] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bemUf-0008HR-C5 for pgsql-hackers@postgresql.org; Tue, 30 Aug 2016 17:06:43 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay06.b.hostedemail.com (Postfix) with ESMTP id 54C218D2BA; Tue, 30 Aug 2016 17:06:36 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::,RULES_HIT:41:355:379:599:967:973:988:989:1260:1263:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1539:1593:1594:1595:1596:1711:1714:1730:1747:1777:1792:2393:2525:2560:2563:2682:2685:2828:2840:2859:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3351:3865:3866:3867:3868:3870:3871:3872:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4184:4605:4659:5007:6261:9025:9121:10004:10394:10400:10848:11026:11232:11256:11257:11658:11914:13069:13161:13229:13311:13357:13439:13894:13895:14180:14721:14764:21060:21080:30054,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:fn,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:3,LUA_SUMMARY:none X-HE-Tag: toy25_73cb46e9e3f05 X-Filterd-Recvd-Size: 1539 Received: from alvin.alvh.no-ip.org (unknown [216.155.90.98]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf03.b.hostedemail.com (Postfix) with ESMTPA; Tue, 30 Aug 2016 17:06:35 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 19A821C17; Tue, 30 Aug 2016 14:06:33 -0300 (CLST) Date: Tue, 30 Aug 2016 14:06:33 -0300 From: Alvaro Herrera To: Jesper Pedersen Cc: PostgreSQL Hackers Subject: Re: pageinspect: Hash index support Message-ID: <20160830170633.GA508711@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -0.4 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Jesper Pedersen wrote: > Hi, > > Attached is a patch that adds support for hash indexes in pageinspect. > > The functionality (hash_metap, hash_page_stats and hash_page_items) follows > the B-tree functions. I suggest that pageinspect functions are more convenient to use via the get_raw_page interface, that is, instead of reading the buffer themselves, the buffer is handed over from elsewhere and they receive it as bytea. This enables other use cases such as grabbing a page from one server and examining it in another one. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, 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