Multicolumn hash tables space complexity.

From: Tzahi Fadida <tzahi_ml(at)myrealbox(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Multicolumn hash tables space complexity.
Date: 2005-04-15 00:22:02
Message-ID: 007201c54151$2867e0e0$0b00a8c0@llord
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I hope its not off topic.
I have an algorithm to implement where it needs
to hold the tuples (complete tuples - all columns)
either in a b+tree or a hashtable.
I am concerned about the space such an index will require.
What is the difference in percentages from the size of all
the data not indexed vs. holding it in a b+tree or a hashtable.

also what is the difference when those indices are half-full?

e.g. I understand a b+tree half full in the worse case can take
space as if it was full. I am guessing it's the same with hashtables.

I understand that the HASH indice in postgresql does not support
a multicolumn. What does it take to upgrade it to do that?

Regards,
tzahi.

WARNING TO SPAMMERS: see at
http://members.lycos.co.uk/my2nis/spamwarning.html

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Hallgren 2005-04-15 06:38:49 Re: OUT parameters in PL/Java
Previous Message Tom Lane 2005-04-14 22:11:08 Re: OUT parameters in PL/Java