[OPEN-ILS-DEV] Indexing problem?

[Jason Etheridge]

On Mon, May 5, 2008 at 11:30 AM, Bill Ott <bott at grpl.org> wrote:
> My test database has 360,000+ bib records, and only about 20,000 holdings
> attached.  When performing a simple keyword search from the staff client I
> get hundreds or thousands of results in a couple of seconds.  If I limit
> those to items with holdings or those available, in either the staff client
> or opac, it takes about 60 seconds to receive any results, if it ever
> finishes.

Hey Bill, did you figure this one out?

> Any thoughts on where to start looking?

I'd be tempted to turn up postgres logging and watch what is happening there.

-- 
Jason Etheridge
 | VP, Community Support and Advocacy
 | Equinox Software, Inc. / The Evergreen Experts
 | phone: 1-877-OPEN-ILS (673-6457)
 | email: jason at esilibrary.com
 | web: http://www.esilibrary.com