Shreya Bhargava <shreya_bhargav(at)yahoo(dot)com> writes:
> for each of the above value, I created a hash index on a 1.17GB table.
Hash index build doesn't have any need for workspace, so it will not go
faster with larger work_mem. Try it with a regular btree index.
> Am i missing something?
Have you read the statements in the manual that discourage you from
using hash indexes at all? Our current implementation of them has
no known advantages over a btree, and several major disadvantages.
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: David Wessell||Date: 2007-07-21 20:03:10|
|Subject: Trouble compiling tsearch2|
|Previous:||From: Shreya Bhargava||Date: 2007-07-14 17:23:23|
|Subject: memory paramters for building indexes|