Hash index creation problem

Question posted by: Spacen Jasset (Guest) on October 24th, 2006 09:55 PM

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.

Not the answer you were looking for? Post your question . . .
189,939 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).