Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bmgcL-0004AL-Ve for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 12:27:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bmgcL-00063x-Ac for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 12:27:13 +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 1bmgcJ-00062c-Fn for pgsql-hackers@postgresql.org; Wed, 21 Sep 2016 12:27:11 +0000 Received: from mx1.redhat.com ([209.132.183.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bmgcH-00007S-5z for pgsql-hackers@postgresql.org; Wed, 21 Sep 2016 12:27:10 +0000 Received: from int-mx11.intmail.prod.int.phx2.redhat.com (int-mx11.intmail.prod.int.phx2.redhat.com [10.5.11.24]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx1.redhat.com (Postfix) with ESMTPS id 849ED61E5F; Wed, 21 Sep 2016 12:27:08 +0000 (UTC) Received: from localhost.localdomain (vpn-53-203.rdu2.redhat.com [10.10.53.203]) by int-mx11.intmail.prod.int.phx2.redhat.com (8.14.4/8.14.4) with ESMTP id u8LCR71q020733 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 21 Sep 2016 08:27:07 -0400 Subject: Re: pageinspect: Hash index support To: Michael Paquier References: <20160830170633.GA508711@alvherre.pgsql> <0f99b6b0-0e54-0f6e-9502-f8cb6f194c17@redhat.com> <3493caf5-6d50-8915-7612-bd830972f513@redhat.com> Cc: Jeff Janes , Alvaro Herrera , PostgreSQL Hackers From: Jesper Pedersen Organization: JBoss, by Red Hat Message-ID: <9c46ef79-218f-38f2-d785-fe4630141801@redhat.com> Date: Wed, 21 Sep 2016 08:27:06 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.68 on 10.5.11.24 X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.5.16 (mx1.redhat.com [10.5.110.39]); Wed, 21 Sep 2016 12:27:08 +0000 (UTC) X-Pg-Spam-Score: -10.0 (----------) 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 On 09/21/2016 02:14 AM, Michael Paquier wrote: >> Adjusted in v4. > > Thanks for the new version. > >> Code/doc will need an update once the CHI patch goes in. > > If you are referring to the WAL support, I guess that this patch or > the other patch could just rebase and adjust as needed. > It is the main patch [1] that defines the new constants for page type. But I'll submit an update for pageinspect when needed. > hash_page_items and hash_page_stats share a lot of common points with > their btree equivalents, still doing a refactoring would just impact > the visibility of the code, and it is wanted as educational in this > module, so let's go with things the way you suggest. > Ok. > + > + The type information will be 'm' for a metadata page, > + 'v' for an overflow page, > 'b' for a bucket page, > + 'i' for a bitmap page, and > 'u' for an unused page. > + > Other functions don't go into this level of details, so I would just > rip out this paragraph. > I'll add an annotation for this part, and leave it for the committer to decide, since Jeff wanted documentation for the 'type' information. > The patch looks in pretty good shape to me, so I am switching it as > ready for committer. > Thanks for your feedback ! Best regards, Jesper -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers