Steve Nicolai wrote:
> The software uses the like operator to select these related objects.
> That gets slower as the number of objects increase, even though there
> is an index on id.
See this page for how to create correct indexes for pattern matching
operators:
http://www.postgresql.org/docs
The following bug has been logged online:
Bug reference: 1394
Logged by: Steve Nicolai
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Fedora Core 2
Description:LIKE doesn't seem to use an index
Details:
I've inherited some software that
