Re: hash index improving v3
"Alex Hunsaker" <[email protected]> Fri, 5 Sep 2008 10:12:01 -0600
| Newsgroups | gmane.comp.db.postgresql.devel.patches |
|---|---|
| Message-ID | <[email protected]> |
On Thu, Sep 4, 2008 at 9:48 PM, Alex Hunsaker <[email protected]> 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.... -- Sent via pgsql-patches mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches