dbTalk Databases Forums  

Re: [PERFORM] [BUGS] BUG #2737: hash indexing large tablefails,while

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [PERFORM] [BUGS] BUG #2737: hash indexing large tablefails,while in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Julius.Stroffek
 
Posts: n/a

Default Re: [PERFORM] [BUGS] BUG #2737: hash indexing large tablefails,while - 11-17-2006 , 09:38 AM






Simon Riggs wrote:
Quote:
Do we think there is hope of improving hash indexes?
I thought about this a bit. I have an idea that the hash index might
have the fixed number of buckets specified in create index statement and
the tuples in each of these buckets should be stored in a b-tree. This
should give a constant performance improvement (but based on the number
of buckets) for each fetch of a tuple from index compared to a fetch
from b-tree index.

cheers

Julo



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.