[OPEN-ILS-DEV] very slow ISBN search

[Mike Rylander]

On Fri, Jun 20, 2008 at 2:58 PM, Bill Ott <bott at grpl.org> wrote:
>
>> 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?
>

Indeed.  The on-disk format will be different

 Attached is a patch for Postgres 8.2.9, but it should apply to any
version without any trouble.

-- 
Mike Rylander
 | VP, Research and Design
 | Equinox Software, Inc. / The Evergreen Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: miker at esilibrary.com
 | web: http://www.esilibrary.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pg-8.2.9-blocksize.patch
Type: text/x-diff
Size: 477 bytes
Desc: not available
Url : http://list.georgialibraries.org/pipermail/open-ils-dev/attachments/20080620/7155d912/pg-8.2.9-blocksize.bin