[Info-ingres] When is a table just to damn big?

[Martin Bowes]

Hi Karl,

> That's a weird message. 
Yep.

> Do you need the table key to be btree?  Can it be hash? Hash partitioning doesn't necessarily play well with a btree index.
We are doing lots of inserts into it and it's a big table so I suspect a hash structure would be nasty.

>  My other thought would be to make the partitioning be range partitioning.  I don't know if either will help.
We shied away from range partitioning as the key fields are increasing and we thought any range condition would quickly become poor. 

> Is the DBMS log enabled and is there anything interesting in there?

Yes and No respectively.

Marty