[OPEN-ILS-DEV] very slow ISBN search

Bill Ott bott at grpl.org
Fri Jun 20 14:58:12 EDT 2008


> The second one will take a while, and it is possible for it to fail if
> there are records with fields greater than 2.7k and Postgres was not
> adjusted at compile time to increase the page size.
>
>   
Doh!

ERROR:  index row size 4232 exceeds btree maximum, 2713
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text 
indexing.


I believe you noted to me previously that this requires an initdb after 
the recompile?






More information about the Open-ils-dev mailing list