[OPEN-ILS-DEV] very slow ISBN search

[Mike Rylander]

On Fri, Jun 20, 2008 at 1:46 PM, Bill Ott <bott at grpl.org> wrote:
> Any thoughts on why searching by ISBN would be painfully slow?

In order to speed up initial load there are some indexes that are left
out of the default schema.  Issue the following at the psql prompt:

CREATE INDEX metabib_full_rec_tag_subfield_idx ON metabib.full_rec
(tag,subfield);
CREATE INDEX metabib_full_rec_value_idx ON metabib.full_rec (value);

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.

-- 
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