On 04/26/2013 12:32 PM, Galen Charlton wrote:
Hi,
On Fri, Apr 26, 2013 at 12:25 PM, Joshua D. Drake <[email protected]>
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
