summaryrefslogtreecommitdiff
path: root/releng/management
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2013-01-20 14:59:30 -0600
committerDan McGee <dan@archlinux.org>2013-01-20 15:01:13 -0600
commit1b1b516bd823d807ea81e62fe14fc92c18d0b89d (patch)
treedc5360125caaa5a7a483a750b3e678012f4d757d /releng/management
parentdd8e94f69783365160bcbfda61a9bebea5a71324 (diff)
Query performance enhancements in get_requiredby()
For packages with particularly long lists of provides (e.g. perl), the query was getting a bit out of control with the list of names passed in. However, changing it to simply do a subquery resulted in some really poor planning by PostgreSQL. Doing this as a custom 'WHERE' clause utilizing the 'UNION ALL' SQL operator works very well. Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'releng/management')
0 files changed, 0 insertions, 0 deletions