From: Brett Smith <brett@curoverse.com>
Date: Wed, 18 Mar 2015 14:44:18 +0000 (-0400)
Subject: 5319: Improve collection PDH fix performance with LIKE searches.
X-Git-Tag: 1.1.0~1733^2
X-Git-Url: https://git.arvados.org/arvados.git/commitdiff_plain/1d0aef8fb7bdad6d28976255919f58b719a4342b?hp=1d0aef8fb7bdad6d28976255919f58b719a4342b

5319: Improve collection PDH fix performance with LIKE searches.

PostgreSQL regexp searches use a lot of RAM, and these queries run out
of RAM on qr1hi.  Prefer LIKE queries, which use less RAM and are more
portable.  We have to do multiple searches, but that's life.
---