DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=DgaI+1KuUWa99OgVsvdu+m9lxGjC9Kxw8bki8m7moNlFGyGHipQtMKkpucqo5mxhIE
	cUjtZZBgxcliSRB0VanGqxo9RsGqfR4Cf9OeTSwdbOJn6Pm+u8ob4Y7FVUO1nndMhGh0
	YASQ5WUmmSqv6vVElWD35jWaKrSMrsjKpnDd8=
Message-ID: <34d269d40809050912u33f2afc8mb90e316bc465136e@mail.gmail.com>
Date: Fri, 5 Sep 2008 10:12:01 -0600
From: "Alex Hunsaker" <badalex@gmail.com>
To: "Tom Lane" <tgl@sss.pgh.pa.us>
Subject: Re: hash index improving v3
Cc: "Zdenek Kotala" <Zdenek.Kotala@sun.com>,
 "Xiao Meng" <mx.cogito@gmail.com>,
	pgsql-patches@postgresql.org, "Jonah H. Harris" <jonah.harris@gmail.com>
In-Reply-To: <34d269d40809042048m3b532a5ej7a9588f63a788d0c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <ded849dd0808171846g2c6c65adub942bd2510a6c94f@mail.gmail.com>
	<48BFDA8D.3080506@sun.com> <29987.1220560114@sss.pgh.pa.us>
	<7627.1220569888@sss.pgh.pa.us>
	<34d269d40809041742r6a0703dbgfbdd012f7f19de2e@mail.gmail.com>
	<10995.1220577198@sss.pgh.pa.us> <11525.1220579153@sss.pgh.pa.us>
	<34d269d40809041854g355a8f68ga3a037a69e3d9fcb@mail.gmail.com>
	<11962.1220581027@sss.pgh.pa.us>
	<34d269d40809042048m3b532a5ej7a9588f63a788d0c@mail.gmail.com>

On Thu, Sep 4, 2008 at 9:48 PM, Alex Hunsaker <badalex@gmail.com> wrote:
> (obviously on a 64 bit machine)
> int main(void)
> {
>        unsigned long y = 0;
>        unsigned cnt = 0;
>
>        printf("insert into test_hash (num) values ");
>
>        //while(cnt != LONG_MAX/UINT_MAX)
>        while(cnt < 10000000)
>        {
>                y += UINT_MAX;
>
>                printf("(%ld), ", y);
>
>                cnt++;
>        }
>
>        printf("(0);\n");
>
> }


Argh sorry I must have been smoking something yesterday thats supposed
to be y+= UINT_MAX + 1 so the benchmarking I did was worthless...
running again with the right values....