Re: [HACKERS] [PATCHES] hash index improving v3

Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] http://xiaomeng.yo2.cn //-- // // // FILE NAME : X937out.cpp // // DESCRIPTIVE NAME: Provides X937 Output

Re: [HACKERS] [patch] gsoc, improving hash index v2

(excluding connections establishing) -- Best Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] http://xiaomeng.yo2.cn

Re: [HACKERS] [patch] gsoc, improving hash index v2

sorry, I made some mistake here. The time of the script on two indexes should be btree: 1/0.174700=5.724098s hash-patch: 1/0.199900=5.00250125s On Wed, Aug 6, 2008 at 9:33 AM, Xiao Meng [EMAIL PROTECTED] wrote: Hi, hackers. Here is some test I run on a bigger set. Use a word list of 39916800

[HACKERS] [patch] gsoc, improving hash index v2

) return false; test = FunctionCall2(key-sk_func, datum, key-sk_argument); if (!DatumGetBool(test)) return false; key++; scanKeySize--; } return true; } Hope to hear from you. -- Best Regards, Xiao Meng DKERC, Harbin Institute

Re: [HACKERS] [PATCH]-hash index improving

some optimization Tom advised and removed the macro HASHVALUE_ONLY. And I'm working on fixing the problem that it crashed in large data set. I'll post a new patch later. Thank you for all your advice and test. -- Best Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL

Re: [HACKERS] [PATCH]-hash index improving

, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] http://xiaomeng.yo2.cn -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] [PATCH]-hash index improving

the original implementation. It's a preliminary implementation and I'm looking for input here. Hope to hear from you. -- Best Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] http://xiaomeng.yo2.cn diff --git a/src/backend/access/hash

Re: [HACKERS] gsoc, store hash index tuple with hash code only

); +extern TupleDesc _create_hash_desc(); +extern IndexTuple _hash_form_tuple(Relation rel, Datum* values, bool* isnull); /* hash.c */ extern void hash_redo(XLogRecPtr lsn, XLogRecord *record); -- Best Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL PROTECTED] MSN

Re: [HACKERS] gsoc, store hash index tuple with hash code only

= CreateTemplateTupleDesc(1, false); TupleDescInitEntry(tupdesc, 1, hashcode, INT4OID, -1, 0); } firstcall = false; return tupdesc; } but it failed because tupdesc is free later, IMHO. Any advice? -- Best Regards, Xiao Meng DKERC, Harbin Institute of Technology, China Gtalk: [EMAIL

[HACKERS] Is there anyway to create a TupleDesc with uint32 attribute easily?

a tuple and needn't write a function for hash specially. I've tried lookup_rowtype_tupdesc() with INT4OID, but it dosen't work since int is not composite type. Is there any easy way to do it or I should change my design? Hope to hear from you. Thanks! -- Best Regards, Xiao Meng DKERC, Harbin

Re: [HACKERS] Is there anyway to create a TupleDesc with uint32 attribute easily?

a structure HashItem to store it again;-) On Tue, Jul 15, 2008 at 8:04 PM, Heikki Linnakangas [EMAIL PROTECTED] wrote: Xiao Meng wrote: Hi, hackers. I'm working on my gsoc project - improving hash index. I need to create a TupldeDesc with uint32 attribute. Here is the reason why I need it - If we

[HACKERS] gsoc, store hash index tuple with hash code only

_hash_checkpage(Relation rel, Buffer buf, int flags); +extern TupleDesc _create_hash_desc(); +extern IndexTuple _hash_form_tuple(Relation rel, Datum* values, bool* isnull); /* hash.c */ extern void hash_redo(XLogRecPtr lsn, XLogRecord *record); -- Best Regards, Xiao Meng DKERC, Harbin Institute

[HACKERS] [GSoC] Need for advice on improving hash index performance

is coming. Have a good day;-) -- Best Regards, Xiao Meng ━ Data and Knowledge Engineering Research Center,CST Harbin Institute of Technology, Harbin, Heilongjiang, China Gtalk: [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] Blog: http://xiaomeng.yo2.cn -- Sent via pgsql