[OPEN-ILS-GENERAL] SQL Query Performance

[Joshua D. Drake]

On 04/26/2013 12:32 PM, Galen Charlton wrote:
>
> Hi,
>
> On Fri, Apr 26, 2013 at 12:25 PM, Joshua D. Drake <jd at commandprompt.com> wrote:
>> Granted if a unique index is required we can use a unique index as well. My
>> only point was adding a secondary partial index was probably not the way to
>> go and that adding a generic index on barcode would service the user better.
>
> But nobody suggested adding a secondary partial index.  I made
> reference to the Pg documentation concerning partial indexes simply to
> point to a source of more information about the topic being discussed.
>

You are right. I just re-read your message. I apologize, I misread it. I 
still think that my performance suggests are spot on however.

> Pointing to additional reading material is a habit I find hard to
> shake after having consorted with librarians for so long. ;)

Nothing wrong with that. Having documentation back you up is always good.

Joshua D. Drake




-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579