[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