BUG #2737: hash indexing large table fails, while btree of same index works

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...

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-performance by date

  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?