From: | "Balazs Nagy" <bnagy(at)thenewpush(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2737: hash indexing large table fails, while btree of same index works |
Date: | 2006-11-05 13:47:31 |
Message-ID: | 200611051347.kA5DlVCk032222@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-performance |
The following bug has been logged online:
Bug reference: 2737
Logged by: Balazs Nagy
Email address: bnagy(at)thenewpush(dot)com
PostgreSQL version: 8.1.5
Operating system: RHEL4
Description: hash indexing large table fails, while btree of same
index works
Details:
Postgres: 8.1.5
Database table size: ~60 million rows
Field to index: varchar 127
CREATE INDEX ... USING hash ...
fails with a file not found error (psql in verbose mode):
ERROR: 58P01: could not open segment 3 of relation 1663/16439/16509 (target
block 528283): No such file or directory
LOCATION: _mdfd_getseg, md.c:954
VACUUM, VACUUM FULL doesn't help, full dump and reload doesn't help either
CREATE INDEX ... USING btree ...
works fine. Could there be a bug in the hash algorithm's implementation?
System is x86_64 SMP 8 CPU core, 16GB RAM, Fiber channel SAN, kernel
2.6.9-42.0.3.ELsmp
I haven't tried the 8.2beta2 yet, but would be happy to try, as the hash
method is better suited for the kind of index I need...
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Deichen | 2006-11-05 18:18:55 | BUG #2738: CREATE FUNCTION INSTR() in docs |
Previous Message | Zdenek Kotala | 2006-11-04 21:35:33 | Re: 8.2bet2 failed build on Solaris 10 / x86-64 / SUN Studio |
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Bishop | 2006-11-05 20:34:15 | Re: Slow functional indexes? |
Previous Message | korryd | 2006-11-03 19:40:25 | Re: profiling PL/pgSQL? |