Re: hash index improving v3

"Alex Hunsaker" <[email protected]> Wed, 10 Sep 2008 21:45:24 -0600

Newsgroups	gmane.comp.db.postgresql.devel.patches
Message-ID	<[email protected]>

On Wed, Sep 10, 2008 at 10:27 AM, Alex Hunsaker <[email protected]> wrote:
> On Wed, Sep 10, 2008 at 8:47 AM, Zdenek Kotala <[email protected]> wrote:
>> What locale did you use? It would be nice to have also comparing between C
>> and any UTF8 locale. I think we should see big benefit when non C locale is
>> used.
>
> Err yes this was UTF8, Ill see about doing a C locale.
>

And here it with a C locale:

pgbench -c1 -n -t100000 -f bench.sql
cvs head: tps = 5142.784262
v5:           tps = 6169.405965


and just for fun a the same using a btree index
pgbench -c1 -n -t100000 -f bench.sql
cvs head: tps = 5234.680407
v5:           tps = 5286.08252

-- 
Sent via pgsql-patches mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-patches