On Fri, Jun 20, 2008 at 1:46 PM, Bill Ott <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] | web: http://www.esilibrary.com
