472,138 Members | 1,666 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,138 software developers and data experts.

Hash index creation problem

I am running postgresql at version 8.1 on a windows xp desktop machine.

I then loaded 40 million rows into a table of 6 varchar fields ( The sum
total length of a row is on average about 100 characters )

If create a single btree index on one of the shortest fields ( about 6
chars long ) it takes approximately 15 minutes

On the other hand if I try to create a hash index it is still working to
create the index after 5 hours (I stopped the server at this point).
There seems to be something wrong here. I would have expected a hash
index to be quicker to create. At any rate I can't see why it should
take over 5 hours vs 15 minutes for the btree.

I read in some newgroup postings that the hash index isn't quite so
reliable, is this the problem that I have encountered, or do I need to
do anything special when creating a hash index - do I need to run on a
sever OS, for example, for this size of index.

In both cases I am using the bundled pgAdmin console to create the indexes.

I can of course use a btree index, but I wonder what went wrong when I
tried to create a hash index.
Oct 24 '06 #1
0 2952

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Markus Dehmann | last post: by
14 posts views Thread by Sean C. | last post: by
7 posts views Thread by Diane | last post: by
21 posts views Thread by Johan Tibell | last post: by
139 posts views Thread by ravi | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.