Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EE20F65015E for ; Tue, 8 Jul 2008 16:31:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 13863-05 for ; Tue, 8 Jul 2008 16:31:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gmp-eb-inf-2.sun.com (gmp-eb-inf-2.sun.com [192.18.6.24]) by postgresql.org (Postfix) with ESMTP id A24AC650152 for ; Tue, 8 Jul 2008 16:31:18 -0300 (ADT) Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe1.eu.sun.com [192.18.6.10]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m68JVGrT011864 for ; Tue, 8 Jul 2008 19:31:16 GMT Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K3P00J01CVKHZ00@fe-emea-09.sun.com> (original mail from Zdenek.Kotala@Sun.COM) for pgsql-patches@postgresql.org; Tue, 08 Jul 2008 20:31:16 +0100 (BST) Received: from [192.168.1.101] ([89.103.109.2]) by fe-emea-09.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K3P00DONCW3I4C0@fe-emea-09.sun.com>; Tue, 08 Jul 2008 20:31:16 +0100 (BST) Date: Tue, 08 Jul 2008 21:28:27 +0200 From: Zdenek Kotala Subject: Re: page macros cleanup (ver 04) In-reply-to: <486E138F.4060900@sun.com> To: Zdenek Kotala Cc: Pavan Deolasee , Heikki Linnakangas , PostgreSQL-patches Message-id: <4873BFDB.7020702@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-2 Content-transfer-encoding: 7BIT References: <48529B83.9010907@sun.com> <2e78013d0807030450m4cab60d0jd99d1acce59fae56@mail.gmail.com> <486DD1D1.50604@sun.com> <2e78013d0807040150w393ad72codaf06a6ac12a83ce@mail.gmail.com> <486DF644.4070604@enterprisedb.com> <2e78013d0807040350m3b2913cfkceaa70d8f9d697c2@mail.gmail.com> <486E01B0.9050100@enterprisedb.com> <2e78013d0807040404q5ff7f7faq9f87a39e0f0552fa@mail.gmail.com> <486E138F.4060900@sun.com> User-Agent: Thunderbird 2.0.0.12 (X11/20080325) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200807/112 X-Sequence-Number: 6806 Pavan, Heikki, Is it OK now or do you have any comments? Thanks Zdenek Zdenek Kotala napsal(a): > Pavan Deolasee napsal(a): >> On Fri, Jul 4, 2008 at 4:25 PM, Heikki Linnakangas >> wrote: >>> >>> No, there's a itemsz = MAXALIGN(itemsz) call before the check against >>> HashMaxItemSize. >>> >> >> Ah, right. Still should we just not MAXALIGN_DOWN the Max size to >> reflect the practical limit on the itemsz ? It's more academical >> though, so not a big deal. > > Finally I use following formula: > > #define HashMaxItemSize(page) \ > MAXALIGN_DOWN(PageGetPageSize(page) - \ > ( SizeOfPageHeaderData + sizeof(ItemIdData) ) - \ > MAXALIGN(sizeof(HashPageOpaqueData)) ) > > > I did not replace PageGetPageSize(page), because other *MaxItemSize has > same interface. > > Revised patch is attached. > > Zdenek > > > ------------------------------------------------------------------------ > >