Re: [PERFORM] [BUGS] BUG #2737: hash indexing large table fails,while btree of same index works

2006-11-11 Thread Simon Riggs
On Fri, 2006-11-10 at 18:55 -0500, Tom Lane wrote: > [ cc'ing to pgsql-performance because of performance issue for hash indexes ] > > "Balazs Nagy" <[EMAIL PROTECTED]> writes: > > Database table size: ~60 million rows > > Field to index: varchar 127 > > > CREATE INDEX ... USING hash ... I'd be

Re: [PATCHES] [BUGS] BUG #2704: pg_class.relchecks overflow problem

2006-11-11 Thread Tom Lane
Toru SHIMOGAKI <[EMAIL PROTECTED]> writes: > + if (numchecks == 0x7FFF) > + ereport(ERROR, > + > (errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED), > + errmsg("cannot have more than 2^15-1 checks in a > table"))); W